Microsoft Office Tutorials and References
In Depth Information
Resized field list boxes
Position field list
moved to the right
each table’s primary key
appears in a bold font
related table’s foreign key does
not appear in a bold font
field lists and field
Notice that EmployerID in the Employer table appears in a bold font; this indicates that the
field is the table’s primary key (the same is true of PositionID in the Position table). On the
other hand, the EmployerID field in the Position table is not bold, which is a reminder that
this field is the foreign key in this table.
To form the relationship between the two tables, you drag the common field of EmployerID
from the primary table to the related table. Then Access opens the Edit Relationships dia-
log box, in which you select the relationship options for the two tables.
7. Click EmployerID in the Employer field list, and then drag it to EmployerID in the
Position field list. When you release the mouse button, the Edit Relationships dialog box
opens. See Figure 3-8.
Edit Relationships dialog box
type of relationship
The primary table, related table, and common field appear at the top of the dialog box. The
type of relationship, One-To-Many, appears at the bottom of the dialog box. When you click
the Enforce Referential Integrity check box, the two cascade options become available. If
you select the Cascade Update Related Fields option, Access changes the appropriate for-
eign key values in the related table when you change a primary key value in the primary
table. You will not select the Cascade Delete Related Records option, because doing so could
cause you to delete records that you did not want to delete; this option is rarely selected.