O'Reilly logo

Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills by Bob Schneider

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

Overriding Referential Integrity

As you can see, the rules of referential integrity are extremely strict. Although they do help ensure the maintenance of data integrity, they can make it difficult to manage your database. For example, as the exercise you just did illustrates, you cannot delete a record in a primary table that has related records in a foreign table. But what if you want to delete such a record? Under what circumstances can it be deleted, and what are the consequences of taking this action?

Two options mitigate the strict rules of referential integrity: Cascade Update Related Fields and Cascade Delete Related Records. These choices are available from the Edit Relationships dialog box, and I describe them shortly. But let me emphasize ...

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