Microsoft® Office Access™ 2007 Plain & Simple

Enforcing Referential Integrity

When you create a relationship between two tables, you need to make sure that data in the two tables remains consistent. If you no longer order from a supplier, you would want all products from that supplier deleted from the Products table when you delete the supplier’s data from the Suppliers table. Enforcing referential integrity lets you do that.

Enforce Referential Integrity

1. Click the Database Tools tab.

2. Click Relationships.

3. Double-click the line representing the relationship you want to edit.

4. Select the Enforce ...