2. ASPRunnerPro General questions
  3. Multiple tables
This topic is locked

Multiple tables

 		10/12/2004 5:16:08 AM
ASPRunnerPro General questions
author

Is it possible to display the results of several tables on the one web page, in the same way as you can with forms in access, where linked data is displayed on the same page?
Sergey Kornilov admin 10/13/2004

David,
no, ASPRunner don't support this.
Pete M 10/13/2004

Sorry to butt in - you can use data from several tables by making a view or query containing the fields, and use that as your data source.
You have to plan it a little if you want to edit the data though - make sure that the editing table is on the left side of the join, and only fields from that table are used in the 'edit' page; you can include all fields in the view page.
This is not the same as a lookup field, but works quite well.