Incorrect results using value lists in searches
I am using FMP12.
I have a field called SELECTIONS which is linked to a value list with 5 values (as checkboxes): Option 1, Option 2, Option 3, Option 4 & Option 5.
If a do a search on SELECTIONS and click the Option 1 and Option 2 checkboxes, the results should be records where only the Options 1 and 2 checkboxes have been clicked.
However, I am getting incorrect results. I am getting records where Option 1 has been clicked and Option 2 has NOT been clicked. Deleting that record and re-entering it does not solve the problem.
Any help on why this is happening and a solution would be appreciated!