Tables, Queries and Mail Merge

[B. Levien]

I am attempting to fix a database that someone else set up.

I have Table01, which has a field called Initials, a field called Full_Name,
and then another for email address and phone number. The Initials field is
the primary key.

The Initials field and Full_Name field are used in other tables as look-up
fields (Table02).

A query was created based on Table02 (and 2 other tables). The Query itself
looks fine, but when I do a Mail Merge in Word, when I insert the Full_Name
field, it shows up as initials.

Can anyone point me in the right direction to find why it's pulling intials
into the Word document when I want the full name (and the query SHOWS the
full name).

Note: in Design View of the Query, if I try to show Table01 with the
Full_Name and Initials field, the entire query is blank.

Thank you for any assistance.

 

[Kevbro7189]

I'm thinking it might be because the Initials are the primary key. Try
removing the Initials from your Query and see what happens.

 

[John Spencer]

Add Table01 into your query and join the initials field in table01 to the
FullName field in table02. Now in the query use the FullName field from table01.

The problem is that Access is actually storing the Initials value in the
FullName field of table02 and through a hidden mechanism (probably a query) is
showing you the value of the FullName field from Table01.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

 

[B. Levien]

Thanks!

I ended up removing the Primary Key, deleting the relationships, and
re-doing them ... it now works like a charm!!!!

This discussion group is WONDERFUL!!!!