linking option to select from A not on B 1

[solmskid]

Using : CR XI
DataSource: Access DB(A)linked to SAP R/3 table(B)(ORACLE)

Situation : (A) has target contract numbers, (B) has all contract numbers.

Desired Result: Link the (A) to (B) by contract number with a link option that will select only a those from (B) that
DO NOT MATCH those in (A)

Thanks...

 

[synapsevampire]

That's built in to Access as a query wizard.

Click the New button in queries and select Find Unmatched.

Now use that query in Crystal.

-k