Enable or disable automatic joins in queries

Even if you haven't created relationships between tables, Microsoft Access automatically creates joins if you add two tables to a query and the tables each have a field with the same or compatible data type and if one of the join fields is a primary key. You can enable or disable these automatic joins.

1. On the Tools menu, click Options.
2. Click the Tables/Queries tab.
3. Select or clear the Enable AutoJoin check box.

Note   This setting applies to new queries only.