Data returning a number in external merge or database query

[pkeegs]

I have just set up a client database in which I select an address town from a
dropdown based on a table with TownID and Town fields. When I merge to a Word
Document or to an Excel Database query the TownID rather than the Town is
returned even though in Access the source table has returned the town. I know
that I can get the correct return if I set up the table without the TownID
field, but there must be an answer to return the correct field. Any ideas
welcome. - regards

 

[pkeegs]

Thanks Allen - It's often the simple things that we miss.