• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Lesson 25. Creating Relationships Betwee... > What is Referential Integrity?

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 the Color ID field in the Coloring table (the one side).


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint