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!
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
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.
"A Successful man is one who can build a firm foundation with the bricks that others throw at him"