A relationship establishes the association between common fields in two tables.
An AutoNumber field can be related to a field of either type AutoNumber or type Text.
Joins specify that each pair of rows that satisfy the join conditions will be combined in the results to form a single row.
Access will automatically create a join only if the field names in both tables are the same.