How to create a "Pick List" page and generate a detail pageSUMMARYIn 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.. You can see the query in action before you start. MORE INFORMATIONThis 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. Part 1 - create the detail display page 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. Part 2 - create the "pick list" page 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). Part 3 - Test your pages Preview picklist.asp in your browser; choose a record by clicking on a hyperlinked ID field.
|
