Spider Web Woman Designs
In this tutorial, we are going to create a "pick list" page from which you can select a record via a hyperlink and display the detail for that record on another page.
This article assumes that you have already imported your database into your web, and that FrontPage has created the fpdb folder, put the database in that folder, and created the global.asa file and the database connection. Please review How to create a FrontPage Database Connection for more information. For this tutorial, we will be using a database called autos.mdb that you can download from this site. We are going to name the Database connection "myautos". We are going to use the "cars" table.
Create a new page and save it as display.asp
Insert | Database | Results
Step 1: Use an existing database connection: myautos
Step 2: Record source: cars
Step 3: Click More Options, Criteria, Add, and use ID as the field name, make sure that the "Use this search form field" box is checked.
Click OK 3 times.
Click Next.
Step 4: Click Next
Step 5: Display all records together, uncheck the box "Add search form", and click Finish
Save the page (as display.asp) and close it.
Create a new page and call it picklist.asp
Insert | Database | Results
Step 1: Use an existing database connection: myautos
Step 2: Record source: cars
Step 3: Edit the list of fields, highlight model and numDoors and remove them from the list and click OK, click Next
Step 4: Click Next
Step 5: Display all records together and click Finish
In Normal View, right-click on <<ID>> in the Database Results Region, choose Hyperlink.
In the Create Hyperlink dialog box, choose display.asp, then click Parameters, Add, click in the Path box, Insert Field Value, choose ID from the dropdown list.
Click OK twice.
Save the page (as picklist.asp).
Preview picklist.asp in your browser; choose a record by clicking on a hyperlinked ID field.