Why don't you post the code that you have and explain explain the results you want to get.
the first dropdown list is for displaying project name and second dropdown list is for displaying approver name associated with selected project name in first dropdown list.
the problem is in second dropdown list the required data is not comming
<!-- project Name drop-down list -->
<tr>
<td><b><font color=blue>Project Name</font></b></td>
<% String CategoryCombo = null;%>
<td><SELECT NAME="pname" id= pname tabindex=5 onchange=location.href='pic_demo.jsp?option'=+this .value;>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newI nstance();
Connection conn = DriverManager.getConnection("jdbc:odbc:Cab");
Statement statement = conn.createStatement();
ResultSet rs = statement.executeQuery("select projname from login where desgn<>'A' group by projname");%>
<OPTION VALUE=0>Choose Project Name</OPTION>";
<%
while(rs.next())
{
CategoryCombo = rs.getString("projname");%>
<option value='<%=CategoryCombo%>' /><%out.println(CategoryCombo);%></option>
<% } %>
</SELECT></td>
</tr>
<!--- This is for approver dropdownlist --->
<tr>
<td><b><font color=blue>Approver</font></b></td>
<%
String ApproverCombo = null;%>
<td><SELECT NAME="Approver" id =Approver tabindex=6>
<OPTION VALUE=0>Choose Approver Name</OPTION>";
<%
ResultSet ss = statement.executeQuery("SELECT name from login where desgn='M' and projname='<%=CategoryCombo%>' ");
while(ss.next())
{
ApproverCombo = ss.getString("name");%>
<option value='<%=ApproverCombo%>' /><%out.println(ApproverCombo);%></option>
<% }
%>
</SELECT>
3
