Find Unmatched Query with two keys

[DanWallace]

Hi,

I'm trying to figure out how to write a Find Unmatched query when I have two keys. The wizard only lets you indicate one.

Table1 has CUSTOMER, ACCOUNT, and a few other tables

Table2 has CUSTOMER, ACCOUNT, and ARCODE

CUSTOMER and ACCOUNT are both keys, meaning there could be many customers each with many accounts. I want to find each individual CUSTOMER/ACCOUNT from Table1 that doesn't have a match in Table2 where ARCODE is "WA"

Any suggestions?

 

[namliam]

Just go to query design, click and drag the fields from one table to the other creating a line between them.

Now double click the line and select the option you want in the popup screen.