I have read the sample and it was very helpful, but I guess I am missing something, because I cannot get the third combo to update properly.
In the attached sample, I have 3 combos: Content Area, Teacher Name, Student Name
When a user changes the Content Area, I want both combos to refresh. It is a true cascade, because the teacher name also determines the list of students.
For demo purposes, I have made it so the students lat names start with the same letter as their teachers. So, if you select [Mathematics], not only should [Euler, Leonhard] appear (which it does), but also his first student [Edwards, Ernie]. This does not happen. The student list remains for the previous teacher, until you manually change that second combo.
I am sure this is simple -- I am probably missing something on the control that would trigger the update to the third combo -- but I've been struggling with this for a few days now and need a more experienced set of eyes.
Suggestions are much appreciated!