ASP page linking field s to 2 different dB,s How??

I have a page that displays a table with several fields/columns....one
of the fields is populated with a a 9 digit # (each one is different)
Each of these #'s relate to another field (and the records are all
different here as well) in a different dB.

I want to make each of the #'s in the 1st page a hyperlink to the
records in the 2nd dB. So when you click on one of the #'s, a second
page comes up with the information corresponding to the # from the 2nd
dB.

I hope that is clear :-)

Can anyone point me in the right direction?
Thanks
Bob

Re: ASP page linking field s to 2 different dB,s How??

wrote in message
news:v773o097ft158ujof1b8i3s9hemgv17umc@4ax.com...
> I have a page that displays a table with several fields/columns....one
> of the fields is populated with a a 9 digit # (each one is different)
> Each of these #'s relate to another field (and the records are all
> different here as well) in a different dB.
>
> I want to make each of the #'s in the 1st page a hyperlink to the
> records in the 2nd dB. So when you click on one of the #'s, a second
> page comes up with the information corresponding to the # from the 2nd
> dB.
>
> I hope that is clear :-)
>
> Can anyone point me in the right direction?
> Thanks
> Bob

Pseudo-code follows for "MyPage.asp":

<% ...

If Request.QueryString = "" Then
Call DB1_List()
Else
Call DB2_Lookup(Request.QueryString)
End If

Sub DB1_List()
...
' build Web page from records; for example:
Response.Write("
target='_blank'>" & objRST("ID") & "")
...
End Sub

Sub DB2_Lookup(ID)
...
' build Web page from record with ID passed.
...
End Sub
%>