Find multiple field values

[mleiser]

I have a day camp application. In a script I go into find mode and let the user choose qualifications to find. To make it simpler, say I have one field that's the month the camper is coming. A second field is the grade they're in. For example, you click on field 1 and choose July or August. In field 2 you get to choose the grade (1, 2, 3 etc.). So if you pick July and grade 3 you'll get a report on those 3rd graders coming in July. What I need to do is allow the user to choose July as before, but multiple grades. For example all 3rd, 4th and 6th graders coming in July. I want a multiple find on one of the fields. How do I do that easily through a script?

[BruceJ]

You may want to try using a portal instead of going into find mode and scripting it.

To do this you have to have fields dedicated to entering find criteria. Then create a relationship between these fields and the target fields. This way you can just use check boxes for the grades to find and it will include all that you check.

[mleiser]

I already have global fields I'm using for the user entry of their choices. Is there any way I can see how to do this in a little more detail? Sounds interesting.