merge fields from linked table

[Dr. Combs]

I am using Office XP. I have an access table in which a
field is a look up linked to another table. When I merge
the table to my word document, the field from the field
linked to the table appears as a number rather than the
text that is in the linked table. How can I get the
actual text to link?

Thanks very much.

 

[Peter Jamieson]

Probably the simplest approach is to create a query in Access that does
explicitly what Access currently does "behind the scenes", the use that
query as the data source for your merge.

For example, suppose you have atable T with fields A, B and C, but A is
actually linked to table L containing fields LA and LT, and what you really
want is the LT corresponding to the LA stored in A, your query might be

SELECT L.LT AS `A`, T.B, T.C
FROM T INNER JOIN L ON T.A = L.LA