name

[JamieM]

I have a field labeled Assigned To: which is a drop down with a list of Staff
ID numbers. I would like to know if there is a way to convert the Staff ID #
to a name in a report. Example: when Staff ID 1234 is selected, I would like
it to show in a text box in the report as "John Smith". Is this possible?
If so, how? Thanks for any help anyone can offer.

Jamie

 

[Tom van Stiphout]

On Mon, 7 Apr 2008 05:10:01 -0700, JamieM

Yes. I.m guessing your report is currently based on a table. Replace
it with a query on that table, and select a second table with
employees. Join the two tables by StaffID (this should be automatic).
Select Employees.StaffName as a field for the query, and bind your
textbox to it.

-Tom.