Multiple Tables queried and then shown 1

[VonFranzken]

I have a really complicated issue.
I have four tables.
No relationship outside of the possibility that they "may" have the same name.
So I have setup two test pages test.asp and test1.asp
I want so that if a person clicks a link on test.asp the results will show up on test1.asp and query the name feilds of the other 3 recordsets to include in the results.

So I setup a common record which I know exists in all four tables. Me. Then on the test.asp I link Me using the id recordset value "aid" I then create a session variable to the value of a recordset "name" or "svname" and then filter the recordsets of the other 3 tables based on the sesion variable, it works but only when you refresh the test1.asp page.

So basically I am querying recordset1 with the aid value and asking the results page to formulate a session variable to the value of the name feild in that same recordset.

Is there anyway to pass the session variable from test.asp and the aid?

Steve

 

[lebisol]

http://www.google.com/search?hl=en&q=ASP+pass+the+session+variable&btnG=Google+Search

:--------------------------------------------------------------------------:

All around in my home town,
They tryin' to track me down...