Field combination from one table that doesn't exist in another

BrianFawcett

Registered User.
Local time
Today, 07:25
Joined
May 3, 2010
Messages
63
I am trying to create a query which I am going to use to build a report. What I need to do is create a condition in the query where i want to return the records for one Table (RFQ Sent) where there are not a corresponding combination of two field (Supplier and Part) in a second table (RFQ received). Can anyone help me out?
 

Users who are viewing this thread

Back
Top Bottom