Share via

Edit or delete a relationship by using the keyboard

  • Article

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 that you have open. You cant modify or delete relationships between open tables.

  2. If you havent 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.