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.
Click the Database Tools tab.
Double-click the line representing the relationship you want to edit.
Select the Enforce ...