1. Select the Item table component.

2. Set the MasterSource property to dsOrder.

3. Select the MasterFields property and press the “…” button. This displays the Field Link Designer.

4. Click on the Available Indexes drop-down list and select ByOrderNo.

5. Select the OrderNo item in the Detail Fields list.

6. Select the OrderNo item in the Master Fields list.

7. Click the Add button. A new item (OrderNo OrderNo) will be added to the Joined Fields list.

8. Press the OK button to close the dialog.

Note: The IndexName property is now set to ByOrderNo. This property was set automatically when we selected the ByOrderNo index in step 4 above. To establish a master detail relationship, the detail table must be indexed on the linking field value or values. You can think of an Index as defining the sort order for the table. Thus, if we need to link the Items table to the Order table based on OrderNo, the Items table must have an index (i.e. sort order) based upon OrderNo.