Hi there
I have made a querry page which shows the various tables stored in the database. each table conatins different data but under the same field Names. How ever the querry is such designed that it displays the table name as the querry result. Now what i want is that wen i click the table name it should display the data stored in them. altough i am able to create the hyperlink on them but not able to program the link that it displays the end result. the code which i have used is given below.


objrs1.Open "Select * from Menu where Center = '"&center&"' and Month = '"&mon&"'",objconn2
for each x in objrs1.Fields
Response.Write "<th>" & x.name &"</th>"
next%>
<tr>
<%
do while not objrs1.EOF
%>
<td><a href ="#">
<% Response.Write objrs1("NCNumber") %></td></a>
<%
Response.Write "<td>" & objrs1("Center") & "</td>"
Response.Write "<td>" & objrs1("Month") & "</td>"
objrs1.MoveNext
endo =true
loop
%>


how can i program this href link to display the NCNumber table stored in another database

Thanks

Something like this

<a href="displaytable.asp?id=<%Response.Write objrs1(("NCNumber"))%>">

and then on request page, get the querystring and display the table based on that..

Charul Shukla

Where is that you are trying to take the user on click of that link?
Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection