User Guide

28
Chapter 3
Creating a Relationship between Tables
The Specify Relationships dialog box allows you to define the relationships between
the tables. If fields from more than one table are selected, you must define at least
one join.
Figure 3-4
Specify Relationships dialog box
Estab
lishing relationships.
To create a relationship, drag a field from any table onto the
field to which you want to join it. The Database Wizard will draw a join line between
the two fields, indicating their relationship. These fields must be of the same data type.
Auto J
oin Tables.
Attempts to automatically join tables based on primary/foreign keys
or matching field names and data type.