QUESTION
So a parent table has multiple children and these children have a field that is either yes/no
I want to make a list view of the parents and one of the searches I want is
“Show me all the parents that have any of the children marked as no”
If you search on the criteria of the children from the parent view will it then check all the children?
Or…
Do I make a new field in the parent, a simple yes/no, that I somehow script/calculate that will on set to ‘yes’ if all the children are ‘yes’?
Is that too vague, hope it makes sense!
ANSWER
Depends exactly what you are trying to achieve.
[1] If you want to send say one generic email to each parent…
From the parent’s table with the children in a portal, search for ‘no’.
This will show one (parent) record immaterial of whether one or many of their children said ‘no’.
It will NOT show any parents whose ALL children (one or many) DID not say NO!!!
[2] If you just want a visual list
Starting on the child table I would search for all the ‘nos’
Sort by parent
OK you’ll get
Jones, Alfie
Jones, Pat
Price, Jake
But you’ll omit all the nos
(interesting by the way… if there’s other values or blanks, and you just want the definite nos,search for nos. If however you want the kids who haven’t said yes, serch for ‘yes’ and omit.)
[3] If you want a nice looking list.
Do as 2
but on the layout add a sub-summary part above the body sorted by parent
you’ll then get
JONES
Alf
Pat
PRICE
Jake
[4] If you wanted to send one email to each parent but name one or more of their children who said no.
Starting on the child table I would search for all the ‘nos’
Sort by parent
then get in a loop
and collated the children’s name in a $ variable
send email to parent (assuming there’s a t/o child > parent
end loop
Hope this helps