Troubleshooting with basic Find function
I have a problem with FMP 10 that's so simple it's that much more confusing that I can't figure it out. When I try to find records in my database in a particular field that contains a checkbox set of values by just checking one of the boxes, the results are randomized and don't follow a pattern. I get the same random results every time I make this search. Am I missing something? The value list of what each checkbox corresponds to is indexed, and I don't have this problem with another checkbox set in my database. As far as I can tell, nothing is different between the problematic value list and the other one that finds records correctly. Any help or suggestions you can offer would be fantastic, thank you very much!