displaying records from data in drop down list

[sunshine3]

Hi all,

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!!

thanks,

sunshine3