Creating a Table From a Form

The purpose of a database is to store information; the place where data is stored is called a table. A table consists of rows and columns. A row, also called a record, contains information about each item you are tracking in the table. A column, also known as a field, stores each characteristic you are tracking in the table.

When creating a form, Web Databases automatically creates a table utilizing the fields created in the form. Tables automatically created by Web Databases from a form begin with FT_ in their names. Once the form is created, access the new table by clicking on the tables link.

Here is an example of the steps needed to create a form:

1. Select Forms from the primary toolbar.
2. Select New from the secondary toolbar.
3. Fill-in the Table name: Contact
4. Fill-in the Description: Product Champion
5. Skip the Data Source.
6. Select the ‘2-pane’ Layout.
7. Click Submit.
8. This will bring you to the Form Designer window.
9. Expanding the selections in Tools menu (on left), build fields that reside in that tables and fill-in boxes on the form.
10. Let’s expand the text fields, select the Single Line option and drag and drop to the first column on the form.
11. Fill in the Label to appear on the form.
12. Fill-in the Field Name as it will appear in the DataStore table.
13. Expand the Options dropdown to mark the field as required.
14. Click Save.
15. Repeat these steps to build a form. Once the form is complete, click Save.
16. To exit the Form Designer form, click the 'X' in the top right corner to close the Form Deisgner window.
17. Access the table by clicking on the tables link.