masterSource

Topic group Related topics Example

A reference to the rowset that acts as the master in a master-detail link and provides parameter values.

Property of

Query

Description

Use masterSource to create a master-detail link between two queries where parameters are used in the detail query. masterSource is assigned a reference to the rowset in the master query.

By setting the masterSource property, the parameters in the SQL statement are automatically substituted with matching fields from the master rowset, thereby constraining the detail query. Calculated fields may be used. The fields are matched to the parameters by name. The field name match is not case-sensitive.

As navigation occurs in the masterSource rowset, the parameter values are resubstituted and the detail query is requeried.

An alternate approach to creating a master-detail link is through the masterRowset and masterFields properties. While masterRowset and masterFields are used to link one rowset to another using an index and matching field values, masterSource creates a query-to-rowset link between the parameters in the detail query and the master rowset.