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"]