ACC: Two Tables Automatically Joined in Query

MORE INFORMATION

Steps to Reproduce Behavior

1. In a new database, create a new table as follows and save it:
   

         Table: Employees
         -------------------------------
         Field Name: ID
            Data Type: AutoNumber (or Counter in version 2.0)
            Indexed: Yes (No Duplicates)
   
         Table Properties: Employees
         -------------------------------
         PrimaryKey: ID
   						

2. Create another new table as follows and save it.
   

         Table: Customers
         -------------------------------
         Field Name: EmployeeID
            Data Type: Number
            Field Size: Long Integer
            Indexed: No
         Field Name: ID
            Data Type: AutoNumber (or Counter in version 2.0)
            Indexed: No
   						

3. Save the table as Customers. Do not create a primary key.
4. Create a new query based on the Employees and Customers tables. Note that the tables are automatically joined on the ID field, where the desired join is from Customers.EmployeeID to Employees.ID.