I was wondering if there is a way to achieve the following:
1) I have an "assignment" related list attached to my contact (i.e. a contact can have multiple assignments)
2) each assignment has a checkbox called "active"
3) I have a checkbox on my contact called "has active assignments"
4) is there a way to make contact."has active assignment" = true if any of the contacts assignments are active?