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

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

For example, in the Coloring field in my Dogs database, I have a number that matches the Color ID field in the Dog Coloring table. The Coloring table lists all the allowable colors for the breed of dog. I don't want my employees to be able to accidentally enter a number in the Dogs table that doesn't match 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 1 side).


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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