Things You'll Need:
-
Step 1
Close all tables that are open.
-
Step 2
Use the F11 key to open the Database window. Click the Table tab.
-
Step 3
Click the Relationship icon on the toolbar, or select Relationships from the Tools menu. A window appears displaying your relationships.
-
Step 4
Locate the tables that you want to change, then double-click on the line that joins them. A window appears.
-
Step 5
Edit the relationship options using the guide in the window.
-
Step 6
Click to set referential integrity if desired. Referential integrity ensures that relationships between related tables are valid and that you don't accidentally delete related data.
-
Step 7
Click OK.







