How to search for records where a certain checkbox is NOT checked? (FM Pro 10 Advanced)
When doing a search, if nothing is entered in a field then that field is basically ignored in a search. That's usually convenient.
So how can we find records where a certain checkbox has not been checked? The checkbox itself is from a value list with one value (Yes). (Is there a better way to have a checkbox?)
I want to look for records satisfying two conditions: (1) a customer is of a certain type and (2) a certain checkbox has not been checked yet.
My purpose is to find and then mail all those customers of that type who have not yet sent us something we requested.