masterFields

Topic group Related topics Example

A list of fields in the master rowset that link it to the detail rowset.

Property of

Rowset

Description

The masterFields property is set in the detail rowset. It is a string that contains a list of fields in the master rowset that are matched against the detail rowset’s active controlling index, as specified by the indexName property. By setting the property in the detail rowset, one master rowset can control multiple detail rowsets.

The masterRowset property should be set before masterFields. Once masterFields is set, by default, the detail rowset is constrained to show the detail rows that match the current row in the master rowset. To override the constraint, set the rowset’s masterChild property to 1 – Unconstrained.

You may cancel the master-detail link by setting either property to an empty string.

For table formats that support multi-field indexes (DBF does not—it uses expression indexes instead), multiple fields in the masterFields list are separated by semicolons.

You may link the rowsets through an expression by creating a calculated field in the master rowset and using that calculated field name in the masterFields list.