Mailing label help

[grachel]

I am trying to create labels from my database which has a relationship to another table "City" heres the problem:

Labels creates
first name last name
address
CITY GIVES A NUMBER ONLY! state zip

Everything is fine except for a number which used to match the primary key in my city table. I changed the primary key to the name of the city but still I get a number instead of the name of the city.

Any help!

thanks

grachel

 

[Matthew Snook]

Can you indicate your table structure and the query you are using to build the mailing list? It sounds like you may need to provide a different field name to the label report to produce the City name instead of the linking field number.

Matt