I've got a requirement in a form that I don't know how to build. At the top of the form, I've got a list of grade levels. Each grade level corresponds to a variable number of programs that grade level is authorized to take.
For instance, if someone selected 'Freshman' in a checkbox at the top of the form, at the bottom of the form, I want to create a select list of programs/courses the grade level is authorized to take. Select 2 grade levels and the list below includes programs/courses for both grade levels and so on. Select 'All' and you get everything.
So, for the sake of an example, say the program level choices are 'All', 'Freshman' and 'Junior' - these are not the real names of the choices nor the actual number - it's only for this example. Also, for the sake of example, say the courses are:
Freshman: Baskets 101, Basic Typing, Beginning Cooking
Junior: Intermediate Camping, Beginning Autocross, Intermediate Knot-Tying
Just FYI, the real list of courses will come from a database of over 200.
Hopefully this is clear enough - many thanks in advance for any and all help.