Salve ho 3 select ke attualmente nn sono combinate eccole qua



<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 '%PROMOZIONE' 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>




<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 '%PROMOZIONE' 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>

<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 '%PROMOZIONE' 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>



Bisogna far diventare tutto combinato in base ai valori in questi 3 campi di questo db

ad esempio all interno questi valori

marca TOSHIBA ACER ASUS
modello i vari sottomodelli
anno

si puo cliccare TOSHIBA e sia modello e anno estrapolano solo i valori corrispondenti al campo TOSHIBA :master:


Fatemi sapere resto in attesa