Hi All,

i have page which shows supplier information in a table format, this
used internally in our company. In order to change or update
information for the supplier, i want to display supplier name in the
table cell as a link.

so if user clicks on the link with the supplier, it should take the
user to another page where user can change information and update it
into database.

but i dont know how to display supplier names as link, as there are
more than one supplier in the table.


If anybody has any other idea to update the information in database,
please share.

Appreciate any ideas on this.

thanks,
Navin

[quoted text, click to view]

I gather that you are looping through the table of suppliers and
generating new rows in an HTML table and that one of the columns
is the supplier name. Just make the supplier name a hyperlink passing
the Supplier's unique ID (autonumber?) in the querystring; for example:

Dim strCOL
strCOL = "<td><a href='Supplier.asp?id=" _
& objRST.Fields("SupplierID").Value _
& "'>" & objRST.Fields("SupplierName").Value & "</a></td>"
Response.Write(strCOL)

[quoted text, click to view]