Data mailmerge problem: Key merges instead of associated data item

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a simple Access DB that has similar fields, each of which uses a
lookup table to select the specific data. Each of the related tables has
only two fields: the Key (autonumber) and the list of items. When I
mailmerge the master table into Word to print certificates, the key number
from each field prints instead of the associated data item. How do I get the
specific data items to print rather than its associated ID (Key) number?
 
Lookup fields are evil! <g> (take a look at
http://www.mvps.org/access/lookupfields.htm at "The Access Web" for some of
the reasons)

You'll need to create a query that joins your two tables so that you get the
description from the lookup table, and use that query, rather than the
table, for your mail merge.
 
Back
Top