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