Selecting data from lookup fields
I'm working producing a set of mailing labels. Access is used to edit/hold the data and Word will be used to do the label merge with the DB as the data source. Here's my problem: I'm having trouble getting the correct data into the merge.
There is a main table with all the relevant address data, but for some reason, the DB was set up with look up fields for the City, State, ZIP, and CompanyName. When I run a simple query to get the info for the labels, the data looks fine in the query window, but when I export or use the query as a data source, I end up with the ID# from each of the smaller tables instead of the City, State, etc...(These tables have an auto-number as the primary key with a description field).
Can someone give me a hand here? I've read through several manuals, but they're not very much help. I appreciate any help I can get. Thank you. -RK
She stood on the bridge at midnight,
Her lips were all aquiver.
She gave a cough,
Her leg fell off,
and floated down the river.