I am creating a db for educators. They have to deal with state standards - large lists of everything a kid needs to know. he structure of the standards is: grade-subject-strand-standard-benchmark.
I want to create a series of value lists that narrow down their choices, i.e., they choose language arts and the strands dropdown value list is reduced to "reading, writing, listening/speaking". When they chose a standards show up as a radio button value list (only those related to strands). When they check a standard, all the related benchmarks show up in a nicely formatted table below. i have set up the db using separate table and everything is properly related.
Can someone help?