O'Reilly logo

Ten Minute Guide to Access 97 by Faithe Wempen

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

What is Referential Integrity?

Referential Integrity keeps you from making data entry mistakes. It says, essentially, that all the information in the two fields should match.

An example will make this clearer. In the Coloring field in my Dogs database, I have a number that matches up with the Color ID field in the Coloring table. The Coloring table lists all the allowable colors for the breed of dog. I don't want my clerks to be able to accidentally enter a number in the Dogs table that doesn't match up with any of the colors in the Coloring table, so I chose to Enforce Referential Integrity. Now Access won't let anyone enter anything in the Coloring field of the Dogs table (the "many" or infinity side) except one of the numbers contained in ...

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