I have CompanyT, AddressT, and IndividualT.  I also have a RelationshipT which I use to link the IndividualT ID's to the CompanyT ID's.

What do I need to add to the existing query below to pick up the individual's full name to address the letter to?  I presume this would need to company from the RelationshipT as this table links the CompanyT and IndividualT together.

Here is the current query:

SELECT CompanyCorrespondenceT.ID, CompanyCorrespondenceT.CompanyNameID, CompanyT.CompanyName, CompanyCorrespondenceT.Date, CompanyCorrespondenceT.Message, AddressT.AddressLine1, AddressT.AddressLine2, AddressT.Town, AddressT.City, AddressT.PostCode, AddressT.Correspondence
FROM (CompanyCorrespondenceT INNER JOIN CompanyT ON CompanyCorrespondenceT.CompanyNameID = CompanyT.CompanyNameID) INNER JOIN AddressT ON CompanyT.CompanyNameID = AddressT.CompanyNameID
WHERE (((AddressT.Correspondence)=Yes));

Here are the fields I have in the RelationshipT:

ID - Autonumber
MainContact - Yes/No
FullNameID - Number
CompanyNameID - Number
Relationship - Text (Director/Sec etc)