Microsoft Office Tutorials and References
In Depth Information
To define the relationship between the Contract and Invoice tables:
1. In the Relationships group on the Design tab, click the Show Table button. The
Show Table dialog box opens.
2. Click Invoice on the Tables tab, click the Add button, and then click the Close
button to close the Show Table dialog box. The Invoice table’s field list appears in
the Relationships window to the right of the Contract table’s field list.
Because the Contract table is the primary table in this relationship, you need to
drag the ContractNum field from the Contract field list to the Invoice field list.
3. Click and drag the ContractNum field in the Contract field list to the
ContractNum field in the Invoice field list. When you release the mouse button,
the Edit Relationships dialog box opens.
4. Click the Enforce Referential Integrity check box, and then click the Cascade
Update Related Fields check box.
5. Click the Create button to define the one-to-many relationship between the two
tables and to close the dialog box. The completed relationship appears in the
Relationships window. See Figure 2-42.
Both relationships deﬁ ned
With both relationships defined, you have connected the data among the three
tables in the Belmont database.
6. Click the Save button
on the Quick Access Toolbar to save the layout in the
7. In the Relationships group on the Design tab, click the Close button to close the
8. Click the File tab on the Ribbon to display Backstage view.
9. Make sure the Info tab is selected in the navigation bar, and then click the
Compact & Repair Database button. Access compacts and repairs the Belmont
10. Click the File tab, and then click Close Database to close the Belmont database.