User-Defined Related Pages

For each conceptual relationship, a related page is generated that displays all related data in the child table, and those parent columns that are contained in the display selection. Here is an example of the object tree of a related page:

The main objects in a related page are:

·	A related data source corresponding with the child table, with a Relate object and Relate columns that specify the foreign key.

The Relate object has a Synchronization Datasource property that specifies the appropriate parent table.

All Relate columns have a Synchronization Column property that specifies the appropriate primary key column in the parent table.

·	A data source corresponding with the parent table. This is a virtual data source: The Synchronization DataSource property is set to the path to the parent table in the calling page, for example:

../TOUR

This results in parent data being available in this related page, without the need to query data again; the query has already been executed in the previous page. The Page Engine takes care of this page stacking mechanism.

·	A parent column group that displays the parent columns that are contained in the display selection.

·	A result group that displays all related (child) data.