How to Set Table Relationships in Access 2013
After you finish adding tables, click the Close button.
Decide which two tables you want to relate.
Since the one-to-many relationship is the most common, these instructions pertain to it. The two tables in a one-to-many relationship are designated as fulfilling either the Parent or Child roles.