I need to create a form using Java Servlets. The Form has 2 fields. 1) Courses which is a combo box with values it gets from a courses db 2) Lecturer which is also a combo box but displays the value according to the value selected in the courses field.
The question is as follows:
Create an Access db named Courses with fileds = course,lecturer,status
Create an html page welcome.html that has a link "Students" This link invokes a servlet that presents a form to evaluate lecturers.
The form has a drop down list named courses, which displays the available courses. It also has a drop down list named lecturers, which displays the available lecturers according to the course selected in the previous courses drop down list.
[The values in the drop down list must be updated when new values are added to the db]