List the name according to the group using dropdown
I have created 1 table called LECTURER.
LECTURER (name, staff_no, title, section .......)
The section example are History, Geograpgy, Literature etc.
How I want to list all the lecturer's name base on the section, let say I chose section history, only lecturers in the section history will be listed.
TQ in advance