Checkbox issues: when searching records, records with marked checkboxes are not all found
Hopefully somebody will recognise my problems with the checkbox. I sent several people from my filemaker adress book an invitation last week. When they respond I mark that with the checkboxset (see picture). I thought it could help me finding the people who will attend more easy. But I just found out that it's not working. I search and mark 1 checkbox, the results also containt records that don't have a marked checkbox and I'm also missing records.
The checkbox get their values from a list.
Can somebody tell me what to do?