sorting with Checkbox Fields
I'm using FMP 8.0 on a Mac.
I have a checkbox field that contains 5 names, where I can check multiple names (let's call it "Name").
I want to run a sort by Name.
It doesn't work at all.
why is that?
Also i'm trying to total all amounts per a given name.
I have a calculation that says:
If (Name="John Smith; Field 1 + Field 2; 0)
this doesn't work either.
thanks so much!