Delete a relationship

1. Close any tables you have open. You can't delete relationships between open tables.
   
   
2. If you haven't already done so, switch to the Database window. You can press F11 to switch to the Database window from any other window.
   
   
3. Click Relationships on the toolbar.
   
   
4. 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.
   
   
5. 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.

Note   You can also delete a relationship by using the keyboard.