How to Create Relationships in Access
How Do You Create a Relationship Between Two Tables in Access? Double-Click the Names of the Tables That You Want to Relate, and Then Close the Show Table...
How do you create a relationship between two tables in Access?
Double-click the names of the tables that you want to relate, and then close the Show Table dialog box. To create a relationship between a table and itself, add that table two times. Drag the field that you want to relate from one table to the related field in the other table.