? about Northwinds query

[bozrdang]

I am trying to learn Access. I often refer to The Northwinds sample database to figure stuff out, but something has me perplexed. When you view the "Orders Qry" query it has an employee field and it displays their full name. When you view it in design mode that same column is actually "EmployeeID" which is an autonumber. How did they get the query to display the full names instead of the corresponding autonumber?

 

[Pat Hartman]

In the table propeties for the EmployeeID field, they defined a lookup to the Employee table. On the surface this looks like a useful thing to do. You can open the orders table and see the employee name rather than a number. However, doing this causes insurmountable problems if you nest queries. I NEVER use the feature. I prefer to create queries that do the necessary joins myself. That way I don't run into problems.

 

[bozrdang]

OK, I see it now. Thanks that had me stumped.