I have two MS-Access Databases.
1.Comp with fields CID, CName, CMarks.
2.Stud with fields SID,SName,SMarks.
I use JSP to build the form in NetBeans.
I want to create a form which would allow me to choose a CName from a drop down menu. When I submit, it should check CMarks select all records in Stud where SMarks>=CMarks.
I do not have a problem, in writing the SQL for CMarks and Selecting Stud Records.
But I would like to know, how to dynamically populate the drop down box, in jsp.