开发者

Showing Actual Data from an Access Lookup Field in Word Mail Merge

开发者 https://www.devze.com 2023-03-13 20:08 出处：网络

I have a lookup field (Dorm) in my Access table of students. Wh开发者_如何学Pythonen I use that table in MailMerge, in Word, the lookup field appears as numbers rather than the dorm. It\'s as if the r

相关专题：email lookup-tables merge ms-access relationship

I have a lookup field (Dorm) in my Access table of students. Wh开发者_如何学Pythonen I use that table in MailMerge, in Word, the lookup field appears as numbers rather than the dorm. It's as if the relationship has been lost in MailMerge. Does anyone know if it is possible to implement a MailMerge with lookup tables, and if so, how?

You should never use lookup fields defined in Access tables:

The Evils of Lookup Fields in Tables

A combo box is a UI object and should be defined at the UI level (in forms, for instance), not in your data tables. What you are experiencing is exactly one of the problems that comes from using them.

Any time I take over an existing Access app, the first thing I do is remove all lookup fields in the data tables. They just get in the way of knowing what the data really is.