Home > Designing and creating solutions > Creating a solution > About defining database fields > Defining fields in Table View

Defining fields in Table View

Use the following steps to create or change fields in a new or existing database.

Note  To have fields that you define in Table View display on a layout, you must select the Add newly defined fields to current layout preference before you define the fields. See Setting layout preferences.

1.	With the database open in Browse mode, click Table View in the layout bar.

2.	In Table View, click the Create Field column heading and type a name for the first field.

3.	The default field type is text. To change the field type, right-click the column heading for the field, then choose Field > Field Type.

See About choosing a field type.

4.	To add a second field, click + in the column heading.

A new field is added to the database and is displayed as the last column in Table View.

5.	Type a name for the field.

See About naming fields.

6.	To select options for the field, right-click the column heading for the field, then choose Field > Field Options.

See Setting options for fields.

7.	Create more fields or add records (rows) to the database.

 

Note  To add an existing field to a layout, switch to Layout mode and drag a field from the Field tool . See Placing and removing fields on a layout.

Related topics 

Defining fields in the Field Picker dialog box

Defining fields in the Manage Database dialog box

Using a reserved word or symbol for a field or table name