Displaying employee name instead of ID

[gweasel]

I've got a form (workorder) that has a combo box for an employee to
select their name when they are creating a new job. On the form, this
works great because I've got the combo box set to display their names,
not their Employee ID numbers (primary key).

Now the problem: I've also got a report (production schedule) which
will be opened by another form more than likely when the workorder
form is not open. I need to display which employee created each job
based on what was entered for the specific LogID, but when I try that
right now, I just get the employeeID number instead of their name.

How can I fix this?

Thanks,
RJB

 

[Allen Browne]

Create a query that uses the Employee table as well as your main table.

You can now add the name fields from the Employee tables to the query
output, and use this query as the RecordSource for your report.