|
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.NET 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.
|
