Auto Look-Up (1 Viewer)

[Cabot]

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 well in the table (I see the employees last names)... here's were I run into my problems.

When I run a query I have to set the criteria with the employee number, it will not work when I attempt to use the name. I am also running into a problem with my reports... it shows me the employee number and I want to see the employee's last name.

Any suggestions?

 

[Hayley Baxter]

Make sure your bound column is set to 1 and the column count is 2. Column width should be 0.

Hay

 

[Cabot]

I do have it set the way you listed and no luck...

I did try something different and it seems to be working better now. Instead of pulling the info from the table where the the auto look up column resides, I have written the query to pull the last name from the employee table and so far so good!

Thanks