Access 2000

[Guest]

I am working with several tables that have relationships, lookup fields, etc.
Also trying to merge with a word document. The field name is
CourseDirector. It is in the table Courses, where the faculty is assigned to
each part of a course, and it looks up the name from the Faculty Table. When
it displays in Access, in the queries, it looks ok, but when merging, it
pulls the FacultyID #. How can I fix this?

 

[John W. Vinson]

I am working with several tables that have relationships, lookup fields, etc.
Also trying to merge with a word document. The field name is
CourseDirector. It is in the table Courses, where the faculty is assigned to
each part of a course, and it looks up the name from the Faculty Table. When
it displays in Access, in the queries, it looks ok, but when merging, it
pulls the FacultyID #. How can I fix this?

You're yet another victim of the misleading, misdesigned Lookup Wizard
misfeature:

http://www.mvps.org/access/lookupfields.htm

The table ACTUALLY CONTAINS the Faculty ID number. That basic fact is
concealed from your view by the lookup wizard! But it's what Word sees
when you do a mail merge.

Instead, create a Query joining this table to (each of) the lookup
table(s), and base your mail merge *on the Query*, not directly on the
table.

John W. Vinson [MVP]