Can I pass an ID from a retrieve table display to a new page?

This is what i try to accomplish:

I retrieve all the new submission from the Customber database based on the date enter by a user.

I have a field call: TestRequest (which is a check box from the customer database)

I have about 10 different tests on the input form. i then create a hyperlink to the individual test page. I try to pass the customer_ID from the table customer to the Test1 form, but the values of Test1 didn't get pass. It is on my local IIS.

Can someone help?

You should try passing the customer ID also in the querystring.

append the querystring like
testrequest.asp?testid=15&custid=254

Or if you use a login script, then a cookie can be retrieved in the testrequest.asp to get the customerid.

I append the querystring in the hyperlink. can i capture it and add the customer_id to the Test1 database?

thanks

I do not understand your question. Can you please explain it further?
What steps you want to get done?
What you have done as of now?
Do you have a login page?

You can get the details from the querystring using

 myvar = Trim(Request.Querystring("var"))

I am new to ASP programming. This operation that i am trying to do is working correctly in MS Access. Now, my boss wants me to web-enable; so that more people can access it. In MS Access, i have customer info as the main form(along with add, edit, delete button); and the TestRequest as the subform.

I do not have a login page; just a simple page asking for what date the user( or data entry operator) would like to retrieve the latest Test Request from tblcustomers (The Test Request form is a form that reside on the internet allowing customers to enter their own information and request which test they want us to perform.)

Based on that date, for example, 11/15/04, it will retrieve all data that is enter after that date. Then on the display list of customers -- the table contains customer info and which test(s) he/she have requested (The customers may request multiple tests to be perform.)

example of my results:

cust_id cust_name submitdate testrequest
1 Joe Smith 11/15/04 Test1
2 John Brown 11/16/04 Test1, Test2

Based on what test the customer requested, i want to make the Test Request (such as Test1) a hyperlink and also pass the customer's id to the TestRequest database table (since different customer can request the same test to be perform). i have the Cust_ID as a foreign key in the TestRequest table. The cust_id is an auto number. Am I doing this problem the wrong way?

thanks

Disregard the previous posting. I try what you suggest (using querystring). I got the customer id value to pass from the query result to display on the Test1 page. Test1 page contains the variable that stores the results of the tests which is on a form. the user enter the results then hit the "submit" button to a page that writes to the database (which now the customer id value is null). I store the customer id value in the Test1 pages in a hidden text input hoping that it will store the value that was pass from the previous page.

on top of Test1 page:

<%
dim ID
ID=Request.querystring("custid")
response.write("<p>customer id is " & ID & " !</p>")
.....
values is ok

at bottom of page before the end of the form:

<input type="hidden" value="ID" name="txtCustID">
.....

on the page that writes to the database (at the top):

Dim ID
ID=Request.form("txtCustID")
response.write("<p>customer id is " & ID & " !</p>")
.......

results (just doing a response.write to check the value):

customer id is ID !


Got any idea how the value has lost along the way?

thanks

<input type="hidden" value="ID" name="txtCustID">

you should have used it like

<input type="hidden" value="<%=ID%>" name="txtCustID">

thanks. it work!