Microsoft Office Tutorials and References
In Depth Information
Session 2.2
TABLE RELATIONSHIPS
The “one” side of a
one-to-many
relationship is
represented by the
digit 1 at the end
of the join line.
The “many” side of a
one-to-many
relationship is
represented by the
infinity symbol at the
nd of the join line.
When you add a table
to the Relationships
window, the fields in
the table appear in a
field list . Here, the
window contains three
field lists, one for each
table: Customer,
Contract, and Invoice.
The primary table
is the “one” table
in a one-to-many
relationship. Here,
Contract is the
primary table
because there is at
most one contract
for each invoice.
The join line connects the
common field used to
create the relationship
between two tables. Here,
the common field
ContractNum is used to
create the one-to-many
relationship between the
Contract and Invoice tables.
The related table is
the “many” table in
a one-to-many
relationship. Here,
Invoice is the related
table because there
can be more than
one invoice set up
for each contract.
Search JabSto ::




Custom Search