Narrowing a Portal List
I have a database of students from a number of years. I would like a list view that I can gradually "narrow". I would like a row of popup menus to perform this "narrowing".
I would first like to have a popup menu for school year, and have the list only display students from that year.
Then a popup menu for School so only those students in a specific school (from that previously selected school year) would display.
Then a popup menu for Grade Level, so only those students in a School Year / School / Grade Level would display.
Then finally a popup menu with teachers, so only those students in a School Year / School / Grade Level / Teacher would display.
I am currently stumped how to do this.