Join/New Join Dialog Box
Use this dialog box to specify tables involved in the join.
Specify the table that contains the field (foreign key) from which the join originates.
Specify the table that contains the field (primary key) to which the join is made.
Specify the fields that make up the primary and foreign keys in the join.
Add, modify, or delete a join condition. Click Add or Edit to display the Join Condition dialog box, where you can select fields to be joined.
Allow outer join
Specify an outer join, because all rows in the source table may not have matching rows in the destination table.
For example, the table Employees contains an employee ID, name, and building ID. The table Buildings contains a building ID and a building name. The question, "Show the employees and their buildings" usually generates a query with an outer join from Employees to Buildings so employees who are not assigned to buildings are also displayed in the result set. If all employees are assigned to buildings, clear this option to improve the performance of the query.