Linking master-detail in local tables

Topic group

Creating a master-detail relationship by using the properties masterRowset and masterFields is the most efficient technique when working with local .DBF tables. It is similar to the older technique of using the SET RELATION and SET INDEX commands, but that technique is no longer recommended.

To link local master-detail tables,

1. Drag the two tables onto the design surface of the designer you’re working in.

2. Select the Query object of the detail table and set its masterRowset property to the name of the master table’s Query object. To do this, select the name of the Query object from the property’s drop-down list (the down-arrow button, not the tool button).

3. With the Query object of the detail table still selected, click the rowset property’s tool button to display the rowset properties.

4. Click the rowset’s masterFields property and from the drop-down list select the fields you want to link from the master table.

5. Set the indexName property to the same field as the masterFields property. If the field names between the two tables are not identical, then in the indexName property select the index that corresponds to the masterFields setting.

6. If you’re designing a report, choose Layout|Add Groups And Summaries, and in the dialog box group the detail fields under the appropriate master-table field.