displaying records from data in drop down list
I have three table :student, team and semester. student and team have a many-to-many relationship and student and semester have a many-to-one relationship.I want a layout that can display all students in a particular team at a particular semester.
That is when i choose a semester from a drop down list , i should be able to see all students who are in a given team during that chosen semester.
Please help me on this one!!