Vi ripropongo questa query con una select ke dovrebbe diventare combinata





<select size="1" name="c" style="font-size: 8 pt; font-family: Tahoma; background-color: #FFFFFF; color: #0066CC; border-style: solid; border-width: 1">

<option value="">MARCA</option>
<%
Set Con = Server.CreateObject("ADODB.Connection")
Set rsQuery = Server.CreateObject("ADODB.Recordset")
Path = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
Path = Path & Server.MapPath("public/database.mdb")
Con.Open Path
Set rs = Con.Execute("select c from tabella1 where accesso = 'SI' and tipologia like 'NUOVO%' group by c order by c Asc")
while rs.eof = false
%>

<option value="<%=Rs(0)%>"><%=Rs(0)%></option>
<%
rs.MoveNext()
wend
rs.close
con.close
%>

</select>


</td>
<td width="80">


<select size="1" name="a" style="font-size: 8 pt; font-family: Tahoma; background-color: #FFFFFF; color: #0066CC; border-style: solid; border-width: 1">

<option value="">MODELLO</option>
<%
Set Con = Server.CreateObject("ADODB.Connection")
Set rsQuery = Server.CreateObject("ADODB.Recordset")
Path = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
Path = Path & Server.MapPath("public/database.mdb")
Con.Open Path
Set rs = Con.Execute("select a from tabella1 where accesso = 'SI' and tipologia like 'NUOVO%' group by a order by a Asc")
while rs.eof = false
%>

<option value="<%=Rs(0)%>"><%=Rs(0)%></option>
<%
rs.MoveNext()
wend
rs.close
con.close
%>



</select>



</td>
<td width="80">



<select size="1" name="b" style="font-size: 8 pt; font-family: Tahoma; background-color: #FFFFFF; color: #0066CC; border-style: solid; border-width: 1">

<option value="">ANNO</option>
<%
Set Con = Server.CreateObject("ADODB.Connection")
Set rsQuery = Server.CreateObject("ADODB.Recordset")
Path = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
Path = Path & Server.MapPath("public/database.mdb")
Con.Open Path
Set rs = Con.Execute("select b from tabella1 where accesso = 'SI' and tipologia like 'NUOVO%' group by b order by b Asc")
while rs.eof = false
%>

<option value="<%=Rs(0)%>"><%=Rs(0)%></option>
<%
rs.MoveNext()
wend
rs.close
con.close
%>



</select>


dove i campi MODELLI e ANNO variano come valori in base alla MARCA cioè alla prima select

marca, modello, anno sono 3 campi del db naturalmente

come può essere modificato tutto questo

fatemi sapere grazie