Microsoft Office Tutorials and References
In Depth Information
Adding relationships
Adding relationships
Access is fantastic for importing data from other sources. After
you’ve imported that data, you might want to create
relationships to existing data. This helps ensure that when new data is
entered , it is consistent. Access allows you to create two kinds
of relationship. The first type simply joins two tables together
and means that when you create queries, Access knows how to
join the tables. This is indicated by a simple line between the
two tables.
The second type of relationship is one that enforces referential
integrity. This is a special relationship, which also has rules to
ensure that the data in different tables is consistent.
Add a relationship
1 In the relationship design view, if the table is not already displayed
in the diagram, click Show Table and select the table from the list of
available tables.
1
Double-click the table name to add the table to the diagram (if
not already displayed). Click Close to close the Show Table popup
window.
2
2
(continued on next page)
TIP To create or edit relationships between tables in the
relationship diagram, the tables must not be open in other tabs
or windows. You should create the relationship between fields that are
of the same data type. If you choose to enforce referential integrity,
any existing data in a field that is part of the relationship must be
consistent with the data on the other side of the relationship. For
example, if we had in the Contacts table a CustomerID with a value of
99 but no record in the Customer table with ID 99, we could not
enforce referential integrity.
Search JabSto ::




Custom Search