Edit an existing relationship (MDB)
Note The information in this topic applies only to a Microsoft Access database (.mdb).
- Close any tables you have open. You can't modify relationships between open tables.
- Press F11 to switch to the Database window.
- Click Relationships on the toolbar.
- If the tables whose relationship you want to edit aren't displayed, click Show Table on the toolbar and double-click each table you want to add.
- Double-click the relationship line for the relationship you want to edit.
- Set the relationship options.