I have an ASP app that uses a access DB and I would like to use case logic to control what is displayed in a drop down.
in my record the players Grade and Sex are known in those names and those two should control the Team field.
For example if Grade = 7 or 8 and Sex = Girl then Teams drop down should have the following
(wildcats, shock, fever, mystics)
If grade = 8 and Sex = Boy then teams = another set of teams
I would have about 10 combinations of Grade and Sex.
This is for a youth non-profit bball league