I have a database with multiple tables. In one of the tables I have a column to auto look up the employees last name to an employee table (these tables are also linked). I have it look up to show me the last name with a primary key set (which is hidden) on their employee number. All works...