Database editing solution

This is really an asp question more so that a db question. Here's the deal:

I have a roster of people from a db showing up in a frame containing ans asp page. In order for the client to edit a record on the roster, I have an edit page opening up in a javascript pop-up. I know how to edit the db but what I don't know is how to 'bind' the text boxes in the pop up to the correct record in the db (based on which record they selected to edit). Here is how it looks:

John Smith 12 123 Main Street Your Town State edit this

the 'edit this' is a link that opens the pop-up. How can I get the correct record to show up in the pop up?

Thanks!!

try using a link that includes url variables that are the primary key for each item e.g.
[code]
<a href="popup_page.asp?id=<%=RS("primarykey")%>">Edit</a>
[!code]

Great idea! Thanks!

here is my pop-up code:


How should I adjust it to accomodate your idea?

Thanks!