Adding related tables

You can use the Related tab in the Add Table dialog box to add tables that are related to the parent table.

The Related tab is only enabled after you add a parent table.

To add a related table:

  1. Select Tables > Add.
  2. In the Add Child Table dialog box, select the related table to add and click OK.
  3. In the Selected Joins dialog box, click Yes to join the tables on the column(s) Direct Link has identified, or click No to create the join manually.
  4. If you clicked No in the previous step, you need to complete the following steps to manually create at least one join between the tables in the Add Join dialog box:
    1. Select the field you want to include in the join from the Parent drop-down list.
    2. Select the field you want to include in the join from the Child drop-down list.
    3. Click OK.
  5. If you need to join the table on additional fields, select Joins > Add and specify the appropriate columns in the Parent and Child drop-down lists and click OK.