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

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