How to create hyperlinks to work with Database Results regions in FrontPage 2002

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

This procedure assumes that Microsoft FrontPage is installed under Microsoft Windows 2000, Microsoft Windows XP Professional, or Microsoft Windows XP Home, that you have already created and saved a Web site and database, and that the database can be accessed over the Web.

Create the Hyperlink Page

1. In Page view, create or open a page that contains a Database Results region that is formatted as a table or list.
   
   Note that you cannot create a hyperlink in a Database Results region that is formatted as a drop-down list.
2. Right-click the Database Results region, and then click Database Results Properties. The Database Results Wizard starts. Click Next to go to step 3.
3. In step 3 of the wizard, click Edit List.
4. In the Displayed fields list, click to select the items that you don't want to be displayed on the Web page. Click Remove, and then click OK.
5. Click Next until you reach the last step of the 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 employees' last names.
7. In the Insert Hyperlink dialog box, type or select the Uniform Resource Locator (URL) of the page on which you want to display the Database Results. Click Parameters, and then click Add.
8. In the Name box, type or select the name of a unique field that contains the values that you want to pass as parameters. Usually this field is the primary key. The Value box will contain the appropriate value.
9. Click OK until you return to the Web page.

Create the Display Page

1. In Page view, 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 Name list, 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 Comparison list, click Equals.
5. In the Value box, 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 this box allows the Database Results region to accept the hyperlink value.
7. Click OK to return to the wizard, and click Next to go to step 5.
8. Click Display all records together, and then click Finish.

NOTE: If you don't want to use the default search feature that appears, drag the mouse pointer to select it, and then press DELETE.