Numbers and not data showing up in mailing labels

[Guest]

When I go to make mailing labels numbers show up and not city or zip
information. I am using a drop down from a seperate table to populate my
main table with this information. The city table has a primary auto number
key and the name of the city. this is true for the zip code too.

How do I get the numbers to display as data

 

[Rick B]

In the query used to create your mailing labels, you need to include the
table where you store the city names. Instead of pulling the city number
from your main table, pull the name from the related table. The same
applies to the ZIPs.

 

[Duane Hookom]

Include the City and Zipcode tables in your report's record source.