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.