Looking for missing criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a one to many table relationship. In the "one" table I have unique
well numbers with descriptive fields. The "many" table is the historical
data of the well as each occurrence happens. I have a field with a combo box
where I pick which action (or historical event) has happened. I would like
to find wells with a particular action. For example: I have entered a new
well in the one but I want to find out if a particular action has not yet
taken place.
 
Sounds like you need something like...

Select * from <onetable> where <onetable.id> not in
(select Id from <manytable> where <action> = 21)

Sorry about the jumble - field names, table names and sample values would
have helped with the clarity

Chris
 
Back
Top