FrontPage 2000 enables you to create a database query that results in a list that displays all of the records in a particular field. This article describes the steps that you can use in one database query to limit the results of another database query.
Position the insertion point somewhere outside the form where you want the filtered database results to be displayed.
On the Insert menu, click Database, and then select Results.
In step 1 of the Database Results Wizard, select your database connection.
Example: Choose Use a sample database connection (Northwind).
In step 2 of the wizard, select your record source.
Example: Choose Products.
In step 3 of the wizard, click More Options, click Criteria, and then click Add. Choose the field that you want to use to filter the database. (NOTE: This must be the same field that you chose when you created the drop-down list earlier in this article.)
Example: Use CategoryID.
Make sure the Use this search form field check box is selected, and then click OK twice.
In the More Options dialog box, click Defaults. Select the query field, click Edit, and then add a default value that matches the field type. (For example, if it is a number field, the default value could be 0.)
Example: Type 0 for the default value; this should return no records.
After typing a default value, click OK three times, and then click Next.
In step 4 of the wizard, choose to return the result to a table, and then click Next.
In step 5 of the wizard, make sure the Add Search Form check box is cleared (not selected), and then click Finish.