Delete a relationship (MDB)
From Microsoft Office Access 2003
Delete a relationship (MDB)
- Close any tables you have open. You can't delete 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 delete aren't displayed, click Show Table
on the toolbar and double-click each table you want to add. Then click Close. - Click the relationship line for the relationship you want to delete (the line will turn bold when it's selected), and then press the DELETE key.