Here's my structure, simplified:

tblContacts
*ContactID
LastName
...

tblAffiliations
*AffiliationID
ContactID
Title
...

qryA:
SELECT tblAffiliations.AffiliationID, tblAffiliations.Title, Null AS
ContactID, Null AS LastName
FROM tblAffiliations;

qryC:
SELECT tblContacts.ContactID, tblContacts.LastName, Null AS AffiliationID,
Null AS Title
FROM tblContacts;

UnionQuery:
SELECT qryA.AffiliationID, qryA.Title, qryA.ContactID, qryA.LastName FROM
qryA

UNION SELECT qryC.AffiliationID, qryC.Title, qryC.ContactID, qryC.LastName
FROM qryC;

In the query results, all records that come from tblContacts have an
illegible, non-western character in the ContactID field.

Many thanks!!

Matthew