This dialog box makes it possible for you to edit a persistent relationship between tables. For more information, see How to: Manage Persistent Relationships Between Tables.
This dialog box appears when you select a relationship line in the Database Designer and select Edit Relationship from the Database menu, or double-click the relationship line.
- Table
- Shows the name of the current parent table and allows you to select a different index tag.
- Related Table
- Shows the name of the current child table and allows you to select a different index tag.
- Relationship Type
- Shows the type of relationship between the parent and child tables.
- Referential Integrity
-
Displays the Referential Integrity builder so you can set up rules to control how records are inserted, updated, or deleted in related tables.
Note: If your tables are not already indexed, you need to open them in the Table designer and create indexes before you use the Referential Integrity builder.