W
Will
2 tables...tblParent and tblChild...
ALL tblChild records have one related record in tblParent with DDD in
fldTitle
SOME tblChild records have _another_ related record in tblParent with CCC in
fldTitle
(So some tblParent records have ONE related tblChild record and some have
TWO.)
I want to find the tblParent records that have NO tblChild record with CCC
in fldTitle
(so these will be the tblParent records with only ONE related record... the
one with DDD in fldTitle)
I have both tables in the query grid with...
tblParent.fldName and tblChild.fldTitle
pulled down to the query grid
Criteria for tblParent.fldName is... Like "AAA*" (this selcts the record
set to consider)
Criteria for tblChild.fldTitle is ... ???? Nothing I try seems to work.
Thanks for any help on how to do this using the query grid...
ALL tblChild records have one related record in tblParent with DDD in
fldTitle
SOME tblChild records have _another_ related record in tblParent with CCC in
fldTitle
(So some tblParent records have ONE related tblChild record and some have
TWO.)
I want to find the tblParent records that have NO tblChild record with CCC
in fldTitle
(so these will be the tblParent records with only ONE related record... the
one with DDD in fldTitle)
I have both tables in the query grid with...
tblParent.fldName and tblChild.fldTitle
pulled down to the query grid
Criteria for tblParent.fldName is... Like "AAA*" (this selcts the record
set to consider)
Criteria for tblChild.fldTitle is ... ???? Nothing I try seems to work.
Thanks for any help on how to do this using the query grid...