Searching by dropdown list
I got 2 tables called student & registration
Student (name, studentID, address, status……..)
Registration(reg_date, month_reg, year_reg, study_level, studentID…….)
Relationship field : studentID
I intend to make searching method by using dropdown list.
For example :
Dropdown list for status (active, non-active, quit, extend)
Dropdown list for reg_date(2009, 2010, 2011)
I want to search students who is active in 2010.
So, how to do that. This searching method I think more flexible compared to write a script for certain button.