I hope I understand what you are asking, if not I am sorry, perhaps my answer will get you closer at least.
It sounds like you want one box to check when all of it's subsidary options are marked off. So you have a field "Life", with one value - complete, and another field, we'll call it "Goals" with some number of possible values, all in a value list set to display as check boxes. You then want "life" to get flagged complete when all of the boxes for "Goals" are checked.
If this is indeed the case then this is one way you could go about it.
I will assume that there are the two fields I described above, and there are also two value lists, "GoalsList" and some value list for LIfe, that I'll call "LifeList", but you can name anything. GoalsList can contain any number of items, and LifeList contans only one value "Complete".
You then want Life to be defined as a text calculation set to equal:
- Code: Select all
If ( Exact ( ValueListItems ( "test" ; "GoalsList") ; LeftWords ( FilterValues ( ValueListItems ( "test" ; "GoalsList") ; Goals) ; WordCount ( Goals ) ) ) ; "Complete" ; "")
Much of this is to deal with the fact that FileMaker does not consistently deal with lists of values, but will get the job done.
If you need any more clarification, just let me know.