Report data display

[fox]

Hello!
I am maintaining a program, and I have some trouble. I want to display a
person name in the report page, but it only display the person id#. I check
the query, it will show the name in query column, but in the report, it only
show id#. I check the table, it display the name because its control source
uses another query to get the name. In the query I working on, it also
display the name, not the id#. But in my report page which using my query, it
will show id# instead of the name. How to make it show the name?

Thank you very much.

fox

 

[Duane Hookom]

It appears you have used a dreaded lookup field in your table design. Don't...

If you want a field value to appear in your report, add the table containing
the field value to your report's record source.