relational mail merge

[Guest]

When pulling a mail merge from Access 2000 to create labels in Word, a
look-up field's reference number comes into the merge rather than the desired
text. How can that be resolved?

 

[Pat Hartman\(MVP\)]

Create a query that joins to the lookup table. Select fields from both
tables. Use the query for the merge rather than the table.

 

[Duane Hookom]

Use a query for the merge rather than the table. This allows you to include
the table with the actual text values.

Consider never using lookup fields in tables
http://www.mvps.org/access/lookupfields.htm.