Simplicty and flexibility!


How to Create a Form over an Existing Table





How to Create a Form over an Existing Table

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.


See Also

On the forum about How to Create a Form over an Existing Table


Product: . Written by alembagheri tahmas 07/12/13 at 13:37:32

Hi there,I am trying to use an external MySQL DB in dataease. I have successfully create the ODBC link and added the DB to dataease. I can also access the DB from dataease. Now, just for testing purposes, I am trying to create a simple report b...

Product: DataEase for Windows 7.x. Written by George Washington 11/04/14 at 08:26:17

no se pude exportar ahora archivos a pdf, ni a excel o otros cosa mala. en verdad creo que hace faltaen las versiones anteriores me funcionaba mas o menos bien. le hace falta a los aplicativos que se desarrollan en Dataeasegr...

Product: DataEase 8 Reporter. Written by eduardo paez 02/05/14 at 14:40:11

Thanks. Anyway I'm trying to use this fuction but it seems to me that it doesn't work on 8.2. I tried also in a DQL.There's something wrong?<img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAA9IAAAJ3CAYAAAB4NWk3AAAAAXNSR0IArs4...

Product: . Written by Marco Marchesi 15/02/16 at 14:50:46


Product: Dataease [{8}]FIVE. Written by Chamil Rajindra 21/02/19 at 10:17:46

Thanks for the very good explanation!AS...

Product: . Written by afonso santos 28/10/19 at 00:50:14

I am pleased to see that the migration from Dos 4.53 is then sa 5.5 works. A really useful thing would be a compiler of SQL languages. Will you get there?Original Text:Mi compiaccio a vedere che la migrazione da Dos 4.53 รจ poi sa 5.5 funzio...

Product: . Written by Grossi Gioacchino 18/11/19 at 14:33:44

On the blog about How to Create a Form over an Existing Table