Using URL links in Access Database??

[pboreham]

I have a table of products in Access and I want to have an (i) Info button that the client can click to open a pop-up browser window with info about that product in.

How can I make each (i) button open only the data relating to that product?? i.e. I need to allocate a URL link to each product where a URL Query will be passed. I've tried a couple of times making a text field 'LINK' in Access, but when I view the page, I get errors.

Does this make sense??? Sorry, I'm kinda new to this!

Thanks for any help,

Paul.

[Husain]

So is the additional information about the products you want to show in another window also in the database?

[pboreham]

Yes, the products description and path to an image is stored in the Access database.

[Technosailor]

you need to query Access to get those ID's and the links BEFORE the user can even click on the (i). Once you have that info, you can echo it back and create the links. But first things first.

Sketch

[pboreham]

Sketch, could you explain a little please - how would I query that first??

Thanks for any help you can give!

Paul

[CMXI_MMI]

Is this what you're looking for?


I'm not sure how to attach this to a button but you can also attach it to dynamic text.

Let's say you want to make the dynamic word Link have a link attached to it and it's ID (based on the database)


Well, the word link would actually look like something like this:
<%=MyRecordSet("Link_Field)%> right? cool. then in order to attach the same recordset's ID to it simply do this
<%=MyRecordSet("Link_Field)%>?id=<%MyRecordSet("ID")%>


------------------
Then on the results page, yours SQL should say something like
"Select * from my table where id="<%RS("ID")%>

I usually let Dreamweaver MX do the coding part.