Display a database value as a hyperlink

To create a web page that shows hyperlinks (from a database) to other files or web sites, carry out the following steps.

Step 1: Add a URL to a database field

In the relevant field in your database, enter a value that represents a URL (of either an absolute or relative file location) that will appear on a web page and point to one of the following:

A file in the same web site and folder as the page that appears when the user clicks the link

To represent a file in the same web site and folder, type the value in this format: filename.htm

A file in the same web site but in a different folder than the page that appears when the user clicks the link

To  represent a file in the same web site but in a folder one level below, type the value in this format: folder/filename.htm

A different web site

To represent a different web site, type the value in this format: http://www.microsoft.com

Step 2: Create the page that will appear when you click the link

  1. Start the Database Results Wizard by clicking the Insert menu, pointing to Database, and then clicking Results.

    Note   If you are using an existing Database Results region, right-click the Database Results region, and then click Database Results Properties to start the wizard.

  2. Click Use an existing database connection, and then select the relevant connection from the list.
  3. Click Next, and then select Record Source.
  4. In the Record Source list, choose the table containing the hyperlink values you entered in step 1.

  5. Click Next for each of the remaining steps of the wizard, and then click Finish.
  6. Double-click the column value corresponding to the database column containing HTML. It will look something like this: <<HYPERLINK>>.
  7. Click Display as Hyperlink.
  8. Click OK

    When the page is viewed in HTTP in a Web browser, the value will be displayed as a hyperlink on the page.