Dear expert - I need help with a query.
I have 3 tables:
Projects - list of projects, with key field Project_ID
Project_Parts - contains Project_ID and Part_ID (it is a list of all parts, by project)
Active_Quotes_Parts - contains Part_ID and other fields - list of all parts that are part of an active quote.
NOW: I want to generate a list of Projects (Project_ID) for which there are parts that are NOT part of active quotes.
(I also have a project table, that lists all projects, for what it's worth).
I tried something along the lines of the attached, with no luck...