admin 11/27/2012 | |
On 'SQL Query' screen in ASPRunnerPro you can add fields from other tables. Use 'Add table' button for this purpose to add the second table and choose one or more fields from joined tables. |
G
|
gdmacdo 11/29/2012 |
Do you mean to have items "displayed" from the Main from in your MainSub? I often have the need to show/display Student information on a form using the StudentID # as the key field. Hello everyone, I have a question on how to do a task. Mainly, is there a way to insert data from a different table in the list, view, add, edit, etc area. Example: I have two database tables, "Main" and "MainSub" with a linked field between the two. I create the ASPRunner list, view, add, edit, etc pages from the table "Main". In the generated pages, can I add another table structure (possible below the generated table) and fill it with the linked data from "MainSub"? What I see in the Editor is the ability to add fields from the same table as the page was generated (Main). Is there a way to add fields from the second database table in the same page from database table "MainSub"? How could I accomplish this please? Your assistance is appreciated. Joe |
|
1312 11/30/2012 |
Thank you both for the response. |