Lookup Pages and Their Data Sources
Lookup pages allow you to query parent records within a parent-child relationship. Lookup pages have almost the same structure as info pages, the main difference being the data sources shown in the object tree:
The Lookup object and its LookupColumn objects specify how a data source is linked to another data source.
In the run-time environment, you can access a lookup page by clicking the lookup button for foreign key fields from the info page corresponding with a child table.
By default, a lookup page does not perform an automatic query when it is opened. You can perform an automatic query by setting the Initial State property to: Query Records.
The Initial State property is a property of the TableDataSource object.