Table Relationships

If you have AutoJoin turned on in Settings/Object Designers when you use the Lookup Wizard in Table Design View your foreign key field will automatically be linked, and you can also check Enable Data Integrity and Cascade or Restrict delete right from the wizard. This is the easiest way to setup your relationships between tables and insure referential integrity between your tables.

To delete a relationship between tables, in the Relationships window, click the relationship line to select it and press the Delete key on your keyboard. Before deleting a relationship make sure that it is not used by a query.

To modify an existing relationship, in the Relationship window, double click the relationship line to open the edit relationships dialog box, make your changes, and click Ok.