Create a form to submit information to a database

From a web site that has an existing database connection, do the following:

1. On the File menu, point to New, and then click Page or Web.
2. In the New Page or Web task pane, under New from Template, click Web Site Templates.
3. Click Database Interface Wizard, and then click Add to current Web.
4. Click OK.
5. In the Database Interface Wizard dialog box, select Use an existing database connection, and then select a database connection from the drop-down list.
6. Click Next.
7. Select the table or view you would like to use for the database connection, and then click Next.
8. If you want to modify a form field, do the following:
   1. Select a value in the Edit form field type list, and then click Modify.
   2. Select a different value in the Form field input type list.

      Note   If you select Option Button as a form field input type, be sure to select a value under Number of options.

9. Click OK, and then click Next.
10. Select Submission Form, and then click Finish.

    Microsoft FrontPage creates:

    • A page titled "Submission Form," which it opens it in Page view.
    • A folder called /Data source_interface/record source (if it doesn't already exist) to store the results page.