Share via


Edit an existing relationship

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

  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 aa170906(v=office.10).md on the toolbar.

  4. If the tables whose relationship you want to edit aren't displayed, click Show Table aa209391(v=office.10).md 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 Aa831220.help1(en-us,office.10).gif, and then click the item.

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