I'm surprised beginning asp databases doesn't cover stuff like this. The way you choose to do it will depend on what your data structure is, but the basic principle is that you provide a hyperlink which contains the data needed to identify the record which contains the detailed information.
For example, say you want to produce a list of books, with a link to detail for each of the authors. Lets say you also have a simple table structure like this (the ExtraInfo field would be the detail you want to show - in reality it could be many fields):
Books - containing ISBN, Title, AuthorID
Authors - containing AuthorID, AuthorName, ExtraInfo
So we want to produce a table containing
ISBN, Title, AuthorName
for each book, and make the AuthorName a link to the ExtraInfo data.
then lets say you select all the books with this SQL
Code:
SELECT b.ISBN, b.Title, b.AuthorID, a.AuthorName
FROM Books b INNER JOIN Authors a
ON b.AuthorID = a.AuthorID
and loop through the resultset (called rs) writing out an html table, you would have something like this:
Code:
... code to connect to db and run the query goes here
Response.Write "<table><tr><td>ISBN</td><td>Title</td><td>Author</td></tr>"
Do While Not rs.EOF
Response.Write "<tr>"
Response.Write "<td>" & rs("ISBN") & "</td>"
Response.Write "<td>" & rs("Title") & "</td>"
Response.Write "<td>"
Response.Write "<a href='detailpage.asp?authorid=" & rs("AuthorID") & "'</a>"
Response.Write rs("AuthorName") & "</td>"
Response.Write "</tr>"
rs.MoveNext
Loop
Response.Write "</table>"
So that's your html table created.
Then you write detailpage.asp which picks up the authorid from the QueryString and uses it to query the Authors table and return and display the ExtraInfo field.
There are other ways to pass AuthorID to the next page (e.g use
js to populate a hidden field in a form and then submit the form), but this gives you the general principle.
hth
Phil