AnsweredAssumed Answered

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

Question asked by douglerner_1 on Feb 4, 2013
Latest reply on Feb 6, 2013 by philmodjunk

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

      

Outcomes