philwes83170
MIS
Here's my situation. I've got a few different ideas how to do this but, just can't wrap my head around the right solution.
I have a View with the following data. An AccountID, ContactID, then four Boolean (T/F) fields. I need to look at each AccountID, then all of the Contacts at once and determine if any of those boolean fields are true. If they are then I want that entire Account group thrown out. I only want to see an AccountID if all of its Contacts have False in all of the boolean fields.
Suggestions on how best to handle this?
I have a View with the following data. An AccountID, ContactID, then four Boolean (T/F) fields. I need to look at each AccountID, then all of the Contacts at once and determine if any of those boolean fields are true. If they are then I want that entire Account group thrown out. I only want to see an AccountID if all of its Contacts have False in all of the boolean fields.
Suggestions on how best to handle this?