Doing a find with checkbox fields

[picnichouse]

Hi,

The interface I've created for to search records includes three checkbox fields, each with several options, i.e. "red," "blue"... "large," "small," etc.

When I select multiple options, I'd like the result to behave in an "or" fashion, rather than "and" -- what I mean is, if I check red and blue, I want all records returned that are red AND all records returned that are blue, not only the records that are both red and blue.

The way I've been doing this is to explode the find into several find records, distributing the checkboxes among the different find records. It's tedious to maintain if I want to change things, and now I am adding another checkbox to the search which will raise the search to a potential of something like 150 different requests.

Is there an easier way?

Andrew

[Sanjai]

I don't think if there is any option other than requesting multiple finds. However, you can make your script generic so that you don't have to worry everytime, you add a new check box.

Therefore, total 4 scripts would be needed to keep track of four fields. You may need a global count field to iterate a loop in each script to repeat the find request for each value checked.

[-Queue-]

The attachment I posted here may be modified for your purposes.