Microsoft Office Tutorials and References
In Depth Information
Session 2.2
Click the Close button to
close th e Relationships
You click the Show Table
button to open the Show
Table dialog bo x. Fro m
there, you can choose a
table to add to the
Relationships window.
The Relationships window
illustrates the relationships
among a database’s tables.
Using this window, you can
view or change existing
relationships, define new
relationships between tables,
and rearrange the layout of
the tables in the window.
The key symbol next to a
field name indicates that
the field is the table’s
primary key. For example,
CustomerID is the primary
key for the Customer table.
A one-to-many relationship
exists between two tables
when one record in the first
table matches zero, one, or
many records in the second
table, and when one record in
the second table matches at
most one record in the first
table. Here, the Customer and
Contract tables have a
one-to-many relationship
because a customer can have
many contracts, and each
contract has only one
customer. The two tables are
still separate tables, but
because they are joined, you
can use the data in them as if
they were one table.
Search JabSto ::

Custom Search