Help Please

[jmlawry]

I got my table loaded from Access on sql on my site. I would like to find out if there is a way to sort the database so I can have separate identies for each item?
I would like to have each item post to its own asp page. If anyone has any suggestions or help they could offer me it would be greatly appericated.

Thanks,
Jean

[chazzy]

do they have primary keys?

[jmlawry]

Yes there is one primary key on the site.

[chazzy]

then i would use that, have the user somehow submit that (maybe have a list of links that get generated w/ the name and id of all the items, they click on the link and it has a query string page.asp?id=ID and you read the query, get the ID and use that value to retrieve the record.