Specifying the Relationship Between the Parent and Child Tables

You have to designate a foreign key column as a key in each child table so that a relationship between each child table and the parent table can be defined. You must also specify the relationship between the primary column in the parent table and the foreign key column in each child table.

1. In the Schema tab, select the User Key check box for the foreign key column in a child table.
2. Click the Join To field next to the appropriate child table column, and select the primary key of the parent table from the list.
   If you select the Allow Key Columns Only check box, child columns are joined only to a key column. If you clear this check box, child columns can be joined to any column.

   The following figure shows the relationship specified between the CUSTOMER parent table and the ORDER_DETAILS child table.