FP2000: How to Filter a Database Query Using a List

ID: Q235554


The information in this article applies to:


SUMMARY

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 you can use to limit the results of another database query.


MORE INFORMATION

To filter a database query using a list, follow these steps:

  1. On the Insert menu, point to Form, and select Form.


  2. Delete the Reset button.


  3. Position the insertion point within the form. On the Insert menu, point to Database, and select Results.


  4. In step 1 of the wizard, select your database connection.


  5. In step 2, select your record source.


  6. In step 3, select Edit List and remove all of the fields, except the one that will be used to query the database. Click OK.


  7. In step 4, click to select Drop-Down List from the list of formatting options.


  8. In step 5, click Finish.


  9. Place your insertion point within the form, where you want the results to be displayed. Repeat steps 3 through 5.


  10. In step 3 of the wizard, click More Options, and click Add. Verify that the Field Name and the Value entries are the same as in step 6. Make sure the "Use this search form field" check box is selected. Click OK twice.


  11. In the More Options dialog box, click Defaults. Click Edit. Add a default value that matches the field type.

    For example: If it is a number field, the default value could be 0.

    Click OK three times.


  12. In step 4, choose to return the result to a table.


  13. In step 5, make sure the Add Search Form check box is not selected. Click Finish



Additional query words: front page


Keywords          : kbdta 
Version           : WINDOWS:
Platform          : WINDOWS 
Issue type        : kbinfo 

Last Reviewed: July 23, 1999