Edit or delete a relationship by using the keyboard

Edit or delete a relationship by using the keyboard

  1. Close any tables that you have open. You can’t modify or 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. Press ALT+T to select the Tools menu, and then press R to open the Relationships window.

  4. Press ALT+R to select the Relationships menu, and then select press R to open the Edit Relationships dialog box.

  5. Press ALT+T. In the Table/Query box, select the name of the table that contains the primary key, and then make sure that the appropriate table appears in the Related Table/Query box.

  6. Set the relationship options if necessary. For more information about a specific item in the Relationships dialog box, select the item, and then press F1.

  7. If you want to delete the relationship, press ENTER, and then press DELETE.