Edit an existing relationship

1. Close any tables you have open. You can't modify 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 edit aren't displayed, click Show Table on the toolbar and double-click each table you want to add.
   
   
5. Double-click the relationship line for the relationship you want to edit.
   
   
6. Set the relationship options. For information about a specific item in the Relationships dialog box, click the question mark button , and then click the item.

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