Creating a Foreign Key

A foreign key associates two tables. Changes to data in one table are reflected in the other table.

To create a foreign key

1. In the Table Editor, open the table where you want to edit a foreign key.
2. Click the Foreign Keys tab.
3. Right-click and select New Foreign Key from the Foreign Keys popup menu. The Foreign Key wizard appears.
4. Enter information in the Foreign Key wizard pages to create the foreign key.
5. Click Finish to create the foreign key.
   Icons for the new foreign key and its joins appear in the Foreign Keys page.
6. Choose Table->Execute to save your changes to the database.