Hi Newbie here, I am busy developing a tour database and need a screen that has the following info from 3 tables linked by the trip code: Trip description from table "trips" list of accommodation types & prices from table "trip accommodation" where key is equal to trip code list of trip dates from table "trip dates" where key is equal to trip code. Is this possible to do with ASPrunner and how? thanks
you can do it editing your SQL query on the Edit SQL query tab.
Use Inner Join clause in your query.
Hi Jane, thanks for that but not quite what I was after. Having looked at the application in more depth I am not sure it is possible without some extra coding but essentially what I was after was a sort of master table type arrangement where I could list all the child tables associated with a master record on one page. So for instance I may have 3 tables (iternary, trip dates, trip accommodation) all linked to master table "trips". If I select the master table I can select each sub table individually for each record in the master table. What I am after is when I select a record from the master table, I want to show all 3 sub tables on one page, not 3 seperate pages (or clicks). From what I can see that there isn't an option to do this in ASPrunner but it is possible to write custom code to do this? Wayne