Having issue with a design. I want a form that has unique info but has multiple records from other tables visible on same page. What is the best way to do. I am using a Inno database with 3 tables.
Scriptcase applications are based upon one table. Then you can bind data from other tables using master-detail setting, nested grids, lookups. So actually your question is hard to answer as there are many options and a bit sparse info.
Although it will take you some time, I advise you to look at the e-learning series which is a broad overview about the possibilties and how things can be done. They can be found on the main website of scriptcase.net