How To Create Hyperlinks to Work with Database Results Regions in FrontPage 2003

Support for Office 2003 has ended

Microsoft ended support for Office 2003 on April 8, 2014. This change has affected your software updates and security options. Learn what this means for you and how to stay protected.

This article has been archived. It is offered "as is" and will no longer be updated.
For a Microsoft FrontPage 2002 version of this article, see 310641.

SUMMARY
This article describes how to create a hyperlink to show additional data in the Database Results region.

This article assumes that Microsoft FrontPage is installed on a computer that is running Microsoft Windows 2000, Microsoft Windows XP Professional, Microsoft Windows XP Home, or Microsoft Windows Server 2003, that you have already created and saved a Web site and database, and that the database can be accessed over the World Wide Web (WWW).

Create the Hyperlink Page

  1. In Pageview, create or open a page that contains a Database Results region that is formatted as a table or list.

    Note You cannot create a hyperlink in a Database Results region that is formatted as a drop-down list.
  2. Right-click the Database Resultsregion, and then click Database Results Properties. The Database Results Wizardstarts. Click Nextto go to step 3.
  3. In step 3 of the Database Results Wizard, click Edit List.
  4. In the Displayed fields list, click to select the items that you do not want to appear on the Web page, click Remove, and then click OK.
  5. Click Nextuntil you reach the last step of the Database Results Wizard, and then click Finish.
  6. Select the field that you want to use for the hyperlink text, and then click Insert Hyperlink. For example, to create an employee listing, select the field that contains the employees' last names.
  7. In the Insert Hyperlinkdialog box, type or select the URL of the page where you want to display the Database Results region, click Parameters, and then click Add.
  8. In the Namebox, type or select the name of a unique field that contains the values that you want to pass as parameters. Typically, this field is the primary key. The Valuebox will contain the appropriate value.
  9. Click OKuntil you return to the Web page.

Create the Display Page

  1. In Pageview, create or open a page that contains a Database Results region that is formatted as a table or list. Make sure that you use the same database connection and record source that you used when you created the first (hyperlink) page.
  2. Go to step 3 of the Database Results Wizard, click More Options, click Criteria, and then click Add.
  3. In the Field Namelist, click the unique field that matches the hyperlink parameter that you selected on the initial results page (most likely the primary key). For example, if you chose a field named EmployeeID as the hyperlink parameter on the initial results page, click EmployeeID.
  4. In the Comparisonlist, click Equals.
  5. In the Valuebox, leave the default value, which is the same as Field Name.
  6. Click to select the Use this search form field check box.

    Although you will not use a search form, selecting theUse this search form field check box allows the Database Results region to accept the hyperlink value.
  7. Click OKto return to the Database Results Wizard, and then click Nextto go to step 5.
  8. Click Display all records together, and then click Finish.
Note If you do not want to use the default search feature that appears, drag the mouse pointer to select it, and then press DELETE.



fp2003
Properties

Article ID: 825500 - Last Review: 01/10/2015 14:24:28 - Revision: 1.7

  • Microsoft Office FrontPage 2003
  • kbnosurvey kbarchive kbhowto KB825500
Feedback