Microsoft Office Tutorials and References
In Depth Information
Creating Relationships and Protecting Your Data with Referential Integrity
Figure 6-2:
The Orders
table
uses the
Contact
ID field
from the
Address
Book table
to identify
customers.
Book II
Chapter 6
Figure 6-3:
Multiple
one-to-
many
relationships
exist among
the tables
in this
database.
Creating Relationships and Protecting
Your Data with Referential Integrity
We’re not referring to your personal relationships. (Well, maybe we are in
an abstract sort of way.) Before you join two tables in the Relationships
window, think about whether you want Access to enforce referential
integrity between those tables. Referential integrity, as the name implies, is all
about making sure that the relationship between two tables doesn’t turn to
total garbage.
Search JabSto ::




Custom Search