How to add a field to a table

Include existing database fields in a model one by one. For example, if a field has been added to a table in a database, it can be made available to and used in an English Query application.

To insert a field in a table

1. On the SQL tab, right-click the table to which a field is to be added and click Add Field.
   
   
2. In the Field Name box, enter the field name.

   Note  Enter the name of each new field on a separate line.

3. Select the Data Type.
   
   
4. If the field is to have a caption, enter one in the Caption box.
   
   
5. On the Basic tab, choose or enter the data type options.

   Note  The available options change with the data type selected.

6. On the Advanced tab, choose or enter the options for allowing Null values, denormalization, and aggregation for the selected field.

See Also

Advanced Tab (Table/New Table Dialog Box)

Basic Tab (Table/New Table Dialog Box)

Model Editor

SQL Tab (Model Editor)

Table/New Table Dialog Box