|
Setting
master-detail relationship between tables
Master-details relationships are very common in applications. An
example of this type of relationship is an order with a header and
line items. In ASPRunner you can join, or link, two or more data sets
that have at least one common field. This topic
explains master-details relationships in great details.
1.
To create master-detail relationship in ASPRunner check off both
master and detail tables in the list of datasource tables.
2.
Drag and drop master key to detail key.
3.
Double click on the relationship line.
4.
Choose Master key(s)
5.
Choose Details table Foreign key(s) (fields that matches Master
key(s) in the Master table)
6.
If you'd like to display Master record info on the Details page check
off corresponding checkbox.
Master page settings:
1. Preview detail records in popup
2. Preview detail records inline
One Master table can have multiple Details tables. |
