When you choose an existing table to create a form that uses a table, DataEase duplicates all the columns in the selected table.

When you create a form that uses a table, you can delete fields from the layout that you do not need in the new document, but you cannot modify a column definition, delete a column, or add a new column in the underlying table.

You can create multiple forms over a single database table, then customize each form for a specific group of users. When a user enters or changes records, DataEase updates corresponding rows in the underlying table.

1. Choose File>>New>>Form;

2. Choose the Style Sheet you want to use;

3. Choose a table name from the Select a Database Table list box and click OK. DataEase displays the “Layout Options” dialog;

4. Alternately, you can fill in the “New Document” dialog and click Query to use the “Query By Model” dialog to choose the tables and columns you want to include in the form;

5. Choose the Field Layout and use the Record Layout Preview Plus and Minus Sign buttons to indicate the number of records to display;

6. Check any Appearance option, such as a title, that you want to include in your layout;

7. Click OK. DataEase automatically arranges all the table columns on your new layout according to the specified Field Layout;

8. Continue designing the layout of the form, creating any additional objects you want to include;

9. Choose File>>Save As. Name the new form and click OK.