Only ID numbers are printing

  • Thread starter Thread starter Vanessa
  • Start date Start date
V

Vanessa

I have Access 2007. I have two tables Contact List and Asset List. I am
trying to print two reports. I want to print the owner and the companies
they lease to from the Asset List. Also from the Contact List I would like
to list the Companies and their Lessors. When I try to do the asset list one
it only gives me id numbers. What am I doing wrong?
 
This is a typical issue when you use lookup fields in tables. My advice is:
don't use them.

Your report's record source must contain the field that actually stores the
value you would like to display in the report.
 
Back
Top