I have a database that when searched it populates a dynamic table with the data from the search. What I am curious on how to do is make one column of the data be returned as a clickable hyperlink. I am guessing that the hyperlink would have to run a query. This query would have to be run agianst the data that was in the table so it could then bring up a form that would be populated by the right record.. Any Ideas or thoughts on how to do this would be much appreciated....

To have a columd display a hyperlink is quite a simple process.

Have a column in your database with the link stored using this format:
www.yoursite.com (do not include the )

then when you make your recordset, add some text into a table cell where you want the link to appear like "Click Here", select this text and click the link folder icon (on the properties panel), now instead of creating the link the normal way by selecting a page, choose "Link from Data Sources" which will be in a little radio button at the top of the browse window.

If you have the recordset created, your list will pop up choose the URL field that your hyperlinks are stored in and select it.

One last thing and your done, in the bottom dialogue box, where it shows your link field add the before it so it looks like
<pre id=code><font face=courier size=2 id=code> &lt;% YourRECORDSETNAME.Fields.Item("URL COLUMN NAME".Value %&gt;</font id=code></pre id=code>

Now when your visitor s click on the Click Here text it will be a hyperlink <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

Regards,
Dave

UD4 | Flash 5 | SQL | Access | ASP/VBScript | XP-Pro