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

Chapter 8. Managing Relationships > Enforcing Referential Integrity

Enforcing Referential Integrity

Referential integrity is a system Access uses to ensure that the data in your database remains consistent. Enforcing referential integrity protects you from accidentally deleting data tied to records in a related table, or from entering records in the foreign (or non-primary) table that aren't related to records in the primary table.

The primary table is the table on the "one" side of a one-to-many relationship. For instance, in a relationship between an Employees table and a Sales table that tracked sales by each employee, the Employees table would be the primary table.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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