Define Relationships by Keyboard

It's not a drag

If you've played with Access, you know that you can create relationships by dragging fields from one table to another.

There is another way to do it using just the keyboard.

I don't know why you would do it this way, but let's assume you lent your mouse to your brother-in-law for the week-end. (?)

1. Close any open tables.
   
   
2. Use F11 to switch to the Database window.
   
   
3. Press ALT+T to select the Tools menu, and then press R to open the Relationships window.
   
   
4. If the Show Table dialog box does not appear, press ALT+R to select the Relationships menu, and then press T to open the Show Table dialog box.
   
   
5. In the Show Table dialog box, select the first table that you want to relate, and then press ENTER to add it to the Relationships window.
   
   
6. Repeat step 5 for any other tables you want to relate, and then press ALT+C to close the Show Table dialog box.
   
   
7. Press ALT+R to select the Relationships menu, and then press R to open the Edit Relationships dialog box.
   
   
8. Press ALT+N to open the Create New dialog box.
   
   
9. In the Left Table Name box, select the name of the table that contains the primary key.
   
   
10. In the Right Table Name box, select the name of the table that contains the foreign key.
    
    
11. In the Left Column Name box, select the primary key field, and in the Right Column Name box, select the foreign key field.
    
    
12. Press ENTER.
    
    
13. In the Edit Relationships dialog box, use the arrow keys to make sure that the two columns contain the field names you want.
    
    
14. Press ALT+C to create the relationship.
    

Support.Microsoft.com:
Define relationships by using the keyboard  




See all Topics