inetserver asp db: I know that there must be a way to do this, but in my limited
knowledge I am stuck.

I am using 2 tables
1. "BTstatus"
BugIndex
Date Entered
Company
Technician
Developer
PROGRAM
Status
PRIORITY

2."noc"
Bugindex
# of calls
Description

Bug index is the common key

I would like to display the first table and when you click on the
Bugindex it would display like a select * from noc where bugindex ='?'
?= the bugindex #

To go along with this on the new screen I would like to be able to
update the # of calls for that particular bugindex. There are a ton of
things out that that are sorta like this but nothing specifically.

OK I am assuming you know how to connect to your database and retrieve =
recordsets for the 2 tables you have mentioned.

Lets the connection object is objConn, the recordsets rsBTStatus and =
rsNOC.

Your main asp page should have the following code:

<%
:
:
<Database connection code>
:
%>
<Table width=3D"100%">
<TR> =20
<TH>BugIndex</TH>
<TH>Date Entered</TH>
<TH>Company</TH>
<TH>Technician</TH>
<TH>Developer</TH>
<TH>PROGRAM</TH>
<TH>Status</TH>
<TH>PRIORITY</TH>
</TR>
<% =20
While not rsBTStatus.EOF
%>
<TR>
<TD>
<A =
HREF=3D'NOC.ASP?Bindex=3D<%=3DrsBTStatus.Fields(0)%>'><%=3DrsBTStatus.Fie=
lds(0)%></A>
</TD>
<TD><%=3DrsBTStatus.Fields(1)%></TD> =20
<TD><%=3DrsBTStatus.Fields(2)%></TD> =20
<TD><%=3DrsBTStatus.Fields(3)%></TD>
<TD><%=3DrsBTStatus.Fields(4)%></TD>
<TD><%=3DrsBTStatus.Fields(5)%></TD>
<TD><%=3DrsBTStatus.Fields(6)%></TD>
<TD><%=3DrsBTStatus.Fields(7)%></TD>
</TR>
<%
rsBTStatus.MoveNext()
Wend
%>
:
:
<Close recrordsets and connection>



Now your NOC.asp page should contain the following code:

<%
:
:
Dim strBugIndex
Dim strSql

strBugIndex =3D trim(Request.QueryString("Bindex"))
:
<Database connection code>
:
strSql =3D "Select * from NOC where BugIndex=3D ' " & strBugIndex & " ' =
=20
(Note: Theres no space between the single and double quotes)

rsNOC.Open strSql, objConn
%>
<Table width=3D"100%">
<TR> =20
<TH>BugIndex</TH>
<TH># of calls</TH>
<TH>Description</TH>
</TR>
<% =20
While not rsNOC.EOF
%>
<TR>
<TD><%=3DrsNOC.Fields(1)%></TD> =20
<TD><%=3DrsNOC.Fields(2)%></TD> =20
<TD><%=3DrsNOC.Fields(3)%></TD>
</TR>
<%
rsNOC.MoveNext()
Wend
%>
:
:
<Close recrordsets and connection>


Havent tested the above code .. but hope you got the idea now .. =
clicking on the BugIndex link on the first page will open a new window =
with the NOC table listing records having the BugIndex that you clicked.

HTH

SPA


[quoted text, click to view]