User manual

Chapter 2 | Using databases 28
Working with data in Table View
You can work with data in Table View to quickly create and change field definitions; add, modify,
and delete records; sort records; create dynamic reports; and create charts. FileMaker
Pro
displays each record in a separate row, and each field in a separate column.
To work with data in Table View, click Table View in the layout bar when you’re working in
Browse mode. You can also work in Table View when you create a new database (see “Creating
a FileMaker Pro file” on page 54).
Displaying data in Table View
You can change the display settings in Table View.
Insert an audio, video, image,
PDF, or other type of file in a
container field
For information, see Help.
Add data to value lists (fields
formatted as radio or option
buttons, checkboxes, lists, or
menus)
For information, see “Setting up checkbox sets and other controls on a layout” on
page 87.
Edit, format, or check the
spelling of text in a field or edit
dictionaries
For information, see Help.
To Click in the field in Browse mode, then
To Do this
Reorder columns Click a column heading and drag it to a new location.
Resize a column Move the pointer to the edge of the column heading. When the pointer changes to a
double arrow ( ), drag it to the desired size.
Set a precise column width Select one or more columns, then right-click and choose Table View > Set Column
Width from the shortcut menu. In the dialog box, type a width, choose units from the
list, then click OK.
Change the color of the
background
Right-click the left or right margin of a record, choose Part Color from the shortcut
menu, then choose a color. The color of the row for adding new records and the
column for adding new fields will be slightly darker than the main background color.
Column headings. Each
column displays one field
from the current layout.
Active
record
Record margin