two tables one that auto fills from the other and merge into micro word

[dkestner]

In access, I have a table with the names of clients and their related information which also includes the names of the insurer which is auto filled from another data base. the auto fill show the insurers name. When I mail merge from the client's table into a word document the insurer name changes to the number of where it fall in the insurer table.

Any suggestions?

[June7]

Suggest not using lookups in table. Review: http://access.mvps.org/access/lookupfields.htm

Build a query that joins clients and insurers tables so all related information is available and use that for the mail merge.

[dkestner]

thanks a little out of my depth but I sure I can string something to gether.

[June7]

What is not clear about the suggestion? Building queries is basic Access functionality.