User manual

Chapter 3 | Designing and creating solutions 47
3. Repeat step 2 to continue defining fields.
4. When you drag fields to the layout, by default the fields are placed vertically on the layout, with
field labels to the left of the fields. To change these settings, click Drag Options before you
drag the fields to the layout.
1 To change the position (horizontal or vertical) in which fields are placed on the layout, for
Field Placement, click a choice.
1 To specify the position of field labels, for Labels, click a choice.
Subsequent fields that are added to the Field Picker dialog box use the current drag settings.
Note Changes to the drag settings have no effect on fields that are already on the layout.
5. Select the fields to place on the layout, then drag them to the layout.
6. Close the Field Picker dialog box by clicking the close button or pressing Esc.
Note To create and change fields in the Manage Database dialog box, see Help.
Creating and changing fields in Table View
1. With the file open, in Browse mode, click Table View in the layout bar.
2. Create new fields or change existing fields.
For information about working with data in Table View (for example, adding, deleting, and sorting
records), see
“Working with data in Table View” on page 26.
Sort fields in the list Click , then choose how to sort the fields.
Locate a field in a long list Type the field name in the search box near the top of the Field Picker
dialog box.
To Do this
Create a field To create the first field, click Create Field in the first column heading. To
create additional fields, click + in the column heading, or click in the right
margin.
Change a field name Double-click the column heading for the field, then type the new name.
See
“About naming fields” on page 43.
Choose a field type Right-click the column heading, choose Field > Field Type, and choose a
field type. See
“About choosing a field type” on page 44.
Important Changing the field type can permanently and irretrievably
erase data.
Set field options Right-click the column heading, then choose Field > Field Options. See
“Setting options for fields” on page 50.
Delete a field Right-click the column heading, then choose Field > Delete Field.
Important Before you delete a field, confirm that you don’t need any of
the data it contains.
To Do this