Joining two tables with two field validators

[jonealmass]

I have two tables I want to join.

Table 1:
Agent ID Agency
2 100
2 101


Table 2:
Agent ID Agency
2 100
2 101
2 102

Table 2 has other field I need but only when Agent ID & Agency from Table 1 equal Agent ID & Agency in Table 2.

 

[Joe4]

Welcome to the Board!

In your query, you can join tables on multiple fields. In the Query Builder, just click and drag from the Agent ID field in Table 1 to the Agent ID field in Table 2. Then do the same for the Agency field.

 

[jonealmass]

I guess I didn't explain right. I have a list of Agent ID's in column A that repeat if they sell in a different firm in Column B. Sales are in separate table. The sales also have Agent IDs & Firm. I need the combination of Agent and firm to bring back sales. But, an agent can have more than what is in the first table but only want the combination. How do I do that?

 

[Joe4]

Can you show some simple data samples of the data in each table, and what you are looking for in your expected results?
I think that will clarify things a bit.