AnsweredAssumed Answered

Using Checkboxes to do a find

Question asked by MishaWeidman on Jul 27, 2012
Latest reply on Jul 30, 2012 by philmodjunk


Using Checkboxes to do a find


I'm a new user of FM Pro12 so pardon me if this is a stupid question.  I regularly need to search records that match several possible criteria within the same field or fields.  For example, let's say I need to find sales of several different products within several different sales districts.  From what I've read it seems like I would need to laboriously add a separate "find" request to extend my search each time (or alternatively do a "constain" request).  Is this really the case?  (I know I can save a complex find to reuse it, but my find requirements change all the time.)

What I'd like to do is set up a special "find" layout with checkbox fields for my sales products and districts so that I can just check the products and districts I'm interested in, hit "find" and have FM return the subset of records that match any of the checked districts together with the checked products.

Any help/clarification much appreciated!