Microsoft Office Tutorials and References
In Depth Information
Establishing Relationships Between Database Tables
violating referential integrity. The best way to solve this problem is to create
a lookup data-entry list in the “many” table with values from the primary key
field in the “one” table. See “Creating a lookup data-entry list,” earlier in this
Editing table relationships
In the Relationships window (refer to Figure 2-11), select the line that represents
the relationship between two database tables and follow these instructions
to edit or remove the relationship:
✦ Editing the relationship: Click the Edit Relationships button or
rightclick and choose Edit Relationship. You see the Edit Relationships dialog
box, where you can overhaul the relationship (the previous topic in this
chapter explains how).
✦ Deleting the relationship: Press the Delete key or right-click and choose
Delete. Then select Yes in the confirmation box.