User manual

Chapter 2
|
Using databases 29
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; and create dynamic reports. 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 55).
Displaying data in Table View
You can change the display settings in Table View.
Working with records in Table View
When you view records in a table, FileMaker Pro displays data in rows and columns. Each row displays a
record, and each column displays a field.
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 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, then choose a color from the Part Color shortcut
menu. 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.
Display a different background
color for alternating records
Right-click the left or right margin of a record, then choose a color from the Alternate Color
shortcut menu.
Restore the default display
settings
Right-click a column heading and choose Reset Table View from the shortcut menu.
Note Resetting Table View doesn’t delete the fields and records.
To Do this in Browse mode
Add a new record Click + in the left margin of the table.
Duplicate a record Right-click the left or right margin of the record that you want to duplicate, then
choose Duplicate Record from the shortcut menu.
Delete a record Right-click the left or right margin of the record that you want to delete, then choose
Delete Record from the shortcut menu.
Column headings. Each
column displays one field
from the current layout.
Active
record