I have an employee table with an "employeeID" autonumber (primary key).  In another table I made a field called "employeeID" as a number, and used it as a foreign key field as I learned in the courses.  Then I made a relationship between the employee table to the order table using a one-to-many relationship - one employee makes many orders.  Now I am running queries and want to retrieve the employee name(s) from the foreign key table - but all I get are the employeeID numbers deposited from the table.  Question:  How do I associate the employeeID numbers back into names of employees?  Many thanks.