12 Replies Latest reply on Feb 6, 2013 11:12 AM by philmodjunk

    How to search for records where a certain checkbox is NOT checked? (FM Pro 10 Advanced)

    douglerner_1

      Title

      How to search for records where a certain checkbox is NOT checked? (FM Pro 10 Advanced)

      Post


           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.

           Thanks,

           doug