Performing an "Or" find with one field

[kikidee]

Hi,

I need help!! I am trying to come up with a way to perform a find which will possibly include more than one value in one field.

Specifically, I have a field, "school". This field is based on a value list of 14 unique values. I would like my users to be able to select more than one school value, as well as any other criteria I have on my search page, and return those records which match all the other criteria selected AND any of the school values selected.

For example - if someone is looking for a software title (which is one field in my db), a version #of that software (another field in my db), and then selects 2 or 3 schools specifically to search, I would like for the records returned to be any record that has the software AND the version selected AND school choice 1 Or school choice 2 or school choice 3.. etc.

Is this possible?

Thanks!!!!!

[color:"purple"]

[-Queue-]

Teach your users about duplicating find requests or adding new ones, or incorporate your find script to automatically create a new request when a find button is clicked a second time. There are a few ways to go about this.

[kikidee]

Thanks for the response.. I would love to avoid teaching them about duplicating find requests - is there any way I can script it so that i duplicate a find request looped 14 times?

[-Queue-]

Of course. But I think it would be more elegant to incorporate this into your find button script, at the user's request instead of automatically.

Here's what you do.

Set Field [globalnumber, 1]

Loop

Duplicate Record/Request

Set Field [globalnumber, globalnumber + 1]

Exit Loop If [globalnumber = 15]

End Loop

[kikidee]

Thanks! I will try it now