Tengo mi pag3 que me muetras una tabla de con mis datos (productos) y en se etiqueta esta como href . Lo que quiero es que al dar click al link (href etiqueta) me direccione a la pag1 que es dond ingrese esos datos y rellene los campos y listas con los datos seleccionados anteriormente.
Espero que se entienda.
Pag1 formulario
<form action="grabadetalle.asp" method="post">
<blockquote>
<blockquote>
<center> <h3><em><strong>Inventario de Bodega</strong></em><br></h3></center>
<HR>
</blockquote>
</blockquote>
<blockquote>
<blockquote>
<h4><em><strong>Ingreso Detalle Producto</strong></em><br></h4>
<HR>
<br>
<font face="Arial Black, Gadget, sans-serif" color="#FF0000" size="+2 ">Cantidad: </font><br>
<input type="text" name="UNI" size="25" value="<%=uni%>"/>
<br>
<br>
Division :
<%
dim etiqueta , cantidad
set dbconnection = server.createobject("ADODB.connection")
dbconnection.open SESSION("DSN_Daniela")
SQLquery="Select nom_div , id_div from Division"
set rs = dbconnection.execute(SQLquery)
%>
<select name="iddivision">
<%
do while not rs.EOF
division=rs("nom_div")
iddivision=rs("id_div")
%>
<option value="<%=iddivision%>"> <%=division%></option>
<%
rs.MoveNext
Loop
%>
</select>
<br>
<br>
Tipo :
<%
set dbconnection = server.createobject("ADODB.connection")
dbconnection.open SESSION("DSN_Daniela")
SQLquery="Select nom_tipo , id_tipo from Tipo"
set rs2 = dbconnection.execute(SQLquery)
%>
<select name="idtipo">
<%
do while not rs2.EOF
tipo=rs2("nom_tipo")
idtipo=rs2("id_tipo")
%>
<option value="<%=idtipo%>"> <%=tipo%></option>
<%
rs2.MoveNext
Loop
%>
</select>
<br>
<br>
Color :
<%
set dbconnection = server.createobject("ADODB.connection")
dbconnection.open SESSION("DSN_Daniela")
SQLquery="Select nom_color , id_color from Color"
set rs3 = dbconnection.execute(SQLquery)
%>
<select name="idcolor">
<%
do while not rs3.EOF
color=rs3("nom_color")
idcolor=rs3("id_color")
%>
<option value="<%=idcolor%>"> <%=color%></option>
<%
rs3.MoveNext
Loop
%>
</select>
<br>
<br>
Capacidad :
<%
set dbconnection = server.createobject("ADODB.connection")
dbconnection.open SESSION("DSN_Daniela")
SQLquery="Select nom_cap , id_cap from Capacidad"
set rs4 = dbconnection.execute(SQLquery)
%>
<select name="idcap">
<%
do while not rs4.EOF
cap=rs4("nom_cap")
idcap=rs4("id_cap")
%>
<option value="<%=idcap%>"> <%=cap%></option>
<%
rs4.MoveNext
Loop
%>
</select>
<br>
<br>
Marca :
<%
set dbconnection = server.createobject("ADODB.connection")
dbconnection.open SESSION("DSN_Daniela")
SQLquery="Select nom_marca , id_marca from Marca"
set rs5 = dbconnection.execute(SQLquery)
%>
<select name="idmarca">
<%
do while not rs5.EOF
marca=rs5("nom_marca")
idmarca=rs5("id_marca")
%>
<option value="<%=idmarca%>"> <%=marca%></option>
<%
rs5.MoveNext
Loop
%>
</select>
<br>
<br>
<input type="button" value="<--- volver" onclick="javascript:document.location.href='formul ario.asp'">
<input type="submit" value="Grabar"/>
</form>
</html>
pag2 graba formulario
<%
iddivision=request("iddivision")
idtipo=request("idtipo")
idcolor=request("idcolor")
idcap=request("idcap")
idmarca=request("idmarca")
code=iddivision & idtipo & idcolor & idcap & idmarca
uni=request.Form("UNI")
set dbconnection = server.createobject("ADODB.connection")
dbconnection.open SESSION("DSN_Daniela")
SQLquery="insert into Etiqueta(id_div,id_tipo,id_color,id_cap,id_marca,e tiqueta,cantidad) values('" & iddivision & "','" & idtipo & "','" & idcolor & "','"& idcap &"','"& idmarca &"','" & code &"','"& uni &"')"
set rs = dbconnection.execute(SQLquery)
%>
</body>
</html>
pag3 Muestra mi lista de productos
set dbconnection = server.createobject("ADODB.connection")
dbconnection.open SESSION("DSN_Daniela")
SQLquery="Select b.nom_div , c.nom_tipo , d.nom_color , e.nom_cap , f.nom_marca , a.cantidad , a.etiqueta from Etiqueta a , Division b , Tipo c , Color d , Capacidad e , Marca f where a.id_div=b.id_div and a.id_tipo=c.id_tipo and a.id_color= d.id_color and a.id_cap = e.id_cap and a.id_marca = f.id_marca"
set rs2 = dbconnection.execute(SQLquery)
%>
<h3><center><em><strong> Lista Productos </strong></em></p></center></h3>
<center><table bgcolor="#FFCC66" frame="below" border="7"></center>
<!--<table width="468" height="160">-->
<tr>
<td width="80">
<font face="Arial, Helvetica, sans-serif" color="#333333"><strong><center>Tipo</center></strong></font>
</td>
<td width="80">
<font face="Arial, Helvetica, sans-serif" color="#333333"><strong><center>Division</center></strong></font>
</td>
<td width="80">
<font face="Arial, Helvetica, sans-serif" color="#333333"><strong><center>Color</center></strong></font>
</td>
<td width="80">
<font face="Arial, Helvetica, sans-serif" color="#333333"><strong><center>Capacidad</center></strong></font>
</td>
<td width="80">
<font face="Arial, Helvetica, sans-serif" color="#333333"><strong><center>Marca</center></strong></font>
</td>
<td width="80">
<font face="Arial, Helvetica, sans-serif" color="#333333"><strong><center>Cantidad</center></strong></font>
</td>
<td width="80">
<font face="Arial, Helvetica, sans-serif" color="#333333"><strong><center>Etiqueta</center></strong></font>
</td>
<%
do while not rs2.eof
%>
<tr>
<td>
<font face="Arial, Helvetica, sans-serif" color="#000000"><center><%=rs2("nom_tipo")%></center></font>
</td>
<td>
<font face="Arial, Helvetica, sans-serif" color="#000000"><center><%=rs2("nom_div")%></center></font>
</td>
<td>
<font face="Arial, Helvetica, sans-serif" color="#000000"><center><%=rs2("nom_color")%></center></font>
</td>
<td>
<font face="Arial, Helvetica, sans-serif" color="#000000"><center><%=rs2("nom_cap")%></center></font>
</td>
<td>
<font face="Arial, Helvetica, sans-serif" color="#000000"><center><%=rs2("nom_marca")%></center></font>
</td>
<td>
<font face="Arial, Helvetica, sans-serif" color="#FF0000"><center><%=rs2("cantidad")%></center></font>
</td>
<td>
<font face="Arial, Helvetica, sans-serif" color="#CC0099"><center><a href="detalle.asp?etiqueta=<%=rs2("etiqueta")%>&"> <%=rs2("etiqueta")%></a></center></font>
</td>
</tr>
<%
rs2.movenext
loop
%>
</table>
<blockquote>
<p><br>
<input type="button" value="<--- volver" onclick="javascript:document.location.href='formul ario.asp'"><br>
</p>
</blockquote>
</html>
----------------------------------------------------------------------------------------------
