I am currently working through Expert 5 where Rick created a query for his letter to pick up name, address etc.

My setup is as follows:

CompanyT
IndividualT
AddressT
RelationshipT

The RelationshipT links the IndividualT record with the CompanyT record using ID's as more than one individual is associated with each company.

AddressT is also being used because each CompanyT / IndividualT record has more than one address. (home, work etc)

This is what I want the query to do:

Individual Name from IndividualT
Company Name from CompanyT
Address from AddressT

But the query should look at the RelationshipT to find the relationship between the CompanyT record and IndividualT record to know which individual to address the letter to.

I have used a yes/no function in the AddressT to identify which addresses for an individual is the correspondence one.

---

Reply from Alex Hedley:

So have you tried joining all the tables together using your JunctionT?