Dynamically binding drop-down lists to value lists
How can I dynamically bind a drop-downlist to a value list based on user's selection (ie in a trigger).
Here's an example,
I have two sets of schools each with 5 teacher name. I have two fields that contain drop down lists one for school name and the other for teacher names. The expected behaviour is that when user selects a school in one field only the teachers from that school will be visible in the teacher Name dropdown list.