Unwanted ID numbers in report

[SlinkRN]

I have a table that stores the employee ID instead of the employee name, the ID is linked to a separate table that stores the ID and the last name and first name. My problem is that I want to print a report based on the table that stores the ID but I would like the last and first names to show on the report instead of the ID. I was able to make the names show up in the table by using a lookup wizard, but the ID still shows up when I pull up the report. Can anyone help? Thanks! Slink

 

[Swamp Thing]

Create a query that pulls the ID from the first table, and the names from the second table. Base the report on this query. Put in controls that are bound to the Name fields of the second table.

 

[SlinkRN]

Thank you so much!!! It worked like a charm