Min teori holdt sq stik....her er løsningen:
<body bgcolor="#336699" text="#FFFFFF" link="#FFFFFF" vlink="#FFFFFF" alink="#FFFFFF" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<%
Set Connect = Server.CreateObject("ADODB.Connection")
Connect.Open "hardware"
sql1 = "SELECT * FROM Kategorier ORDER BY Navn ASC"
Set rs1 = Connect.Execute(sql1)
%>
<table border="0" cellpadding="0" cellspacing="10" width="675">
<%
do while not (rs1.bof or rs1.eof)
%>
<tr>
<td colspan="6" width="675">
<font face="Arial" size="4">
<%=rs1("Navn")%> oversigt
</font>
</td>
</tr>
<tr>
<td width="125">
<font face="Arial" size="2">
<u>Mærke</u>
</font>
</td>
<td width="125">
<font face="Arial" size="2">
<u>Model</u>
</font>
</td>
<td width="175">
<font face="Arial" size="2">
<u>Serienr.</u>
</font>
</td>
<td width="75">
<font face="Arial" size="2">
<u>På lager</u>
</font>
</td>
<td width="50">
<font face="Arial" size="2">
<u>Antal</u>
</font>
</td>
<td width="125" align="right">
<font face="Arial" size="2">
</font>
</td>
</tr>
<%
sql2 = "SELECT * FROM HardwareIndex WHERE Kategori="&rs1("Id")
Set rs2 = Connect.Execute(sql2)
Do while not (rs2.bof or rs2.eof)
%>
<tr>
<td width="125">
<font face="Arial" size="1">
<%=rs2("Maerke")%>
</font>
</td>
<td width="125">
<font face="Arial" size="1">
<%=rs2("Model")%>
</font>
</td>
<td width="175">
<font face="Arial" size="1">
<%=rs2("Serienr")%>
</font>
</td>
<td width="75">
<font face="Arial" size="1">
<%
If rs2("Lagerstatus") = "on" Then
Response.Write("Ja")
Else
Response.Write("Nej")
End if
%>
</font>
</td>
<td width="50">
<font face="Arial" size="1">
<%=rs2("Antal")%> stk.
</font>
</td>
<td width="125" align="right">
<font face="Arial" size="1">
<a href="edit.asp?id=<%=rs2("Id")%>">Ret</a> / <a href='java script:slet("<%=rs2("Id")%>")'>Slet</a>
</font>
</td>
</tr>
<%
rs2.movenext
loop
%>
<%
rs1.movenext
loop
%>
</table>
</body>
Men I har begge to bidraget til min løsning så jeg deler pointene mellem jer.
thomas_yde: Gider du oprette et nyt svar?
