Displaying the wrong info

  • Thread starter Thread starter Oliver
  • Start date Start date
O

Oliver

Hi

I am trying to print a report that tells what projects
are cauurently in the office.

In the form i want to display the Name of the Project
Manager.

In my 'Projects' table the Project Manager feild is a
combo box that is linked to a table called 'Project
Managers'

When i go to print the report, instead of printing the
persons name it prints the autonumber.

Is there any way to fisx this?

Thanks

Oliver
 
Oliver,

Is the recordsource of your report a query, or a table directly?
In the latter case, make a query containing the projects and the project
managers tables, join on the PM_ID field, select the required fields (so PM
name comes from the PMs table), and make this qiery your report's
recordsource.
If you're already using a query, then just add the PMs table and do as
above.

HTH,
Nikos
 
Back
Top