O'Reilly logo

Microsoft® Office Access™ 2007 Plain & Simple by Curtis D. Frye

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required