Report Offensive Message

We've reached our limit of nested replies, so I have to start a new response.

I think the first thing we have to do is define related, so that we're both on the same page with your question. You said that all three tables have a common value, that implies a relationship between the three tables. You should be able to create a multi-join statement that pulls all these records together into a meaningful set of values. It isn't necessary for you to manually create a relationship via Access' Relationship window to make this work.