Viewing records as a form, list, or table

Viewing records as a form, list, or table

You can change the way records display or print.

To view records

Do this in Browse mode, Find mode, or Preview mode

Individually

Click Form View in the layout bar.

In a list

Click List View .

In a spreadsheet-like table

Click Table View .

Each row displays a record, and each column displays a field.

Viewing records as a table

When you view records in a table, FileMaker Pro displays data in rows and columns. While viewing records as a table you can do the following:

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, right-click (Windows) or Control-click (Mac OS). Choose Set Column Width from the shortcut menu. In the dialog box, type a width, choose units from the list, then click OK.

Sort records

Click a column heading.

Or, select one or more columns, right-click (Windows) or Control-click (Mac OS) to display the shortcut menu, then choose a sorting order. If you select multiple columns, the order of the columns (left to right) determines the sort order.

Note You must have Sort data when selecting column selected in the Table View Properties dialog box. See Setting up form, list, and table views for a layout.

Display more fields or hide fields

Click Modify in the layout bar.

See Adding and hiding fields in Table View for more information.

Notes

  •

Some views may not be available for each layout. If you have layout design privileges, you can select the views that are available.

  •

To reorder, resize, or sort data in Table View, you can select multiple columns but you can't select multiple cells.

  •

For layouts that contain tabs, in Form or List View, click a tab to bring the associated tab panel to the front for viewing. Table View displays all fields from each tab panel.

  •

Subsummary parts appear in Table View and List View when sorted by break fields, and update dynamically when you change data in the file.

  •

Table View displays all fields from the body part of the current layout. If a layout contains a portal, Table View displays the data from the first related record (the first row of the portal).

  •

Global fields display one value for all records. You can edit a global field in any row of the table. See Defining global fields (fields with global storage).

Related topics

Creating and managing layouts

Protecting databases with accounts and privilege sets

About FileMaker Pro modes

To view records	Do this in Browse mode, Find mode, or Preview mode
Individually	Click Form View in the layout bar.
In a list	Click List View .
In a spreadsheet-like table	Click Table View . 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, right-click (Windows) or Control-click (Mac OS). Choose Set Column Width from the shortcut menu. In the dialog box, type a width, choose units from the list, then click OK.
Sort records	Click a column heading. Or, select one or more columns, right-click (Windows) or Control-click (Mac OS) to display the shortcut menu, then choose a sorting order. If you select multiple columns, the order of the columns (left to right) determines the sort order. Note You must have Sort data when selecting column selected in the Table View Properties dialog box. See Setting up form, list, and table views for a layout.
Display more fields or hide fields	Click Modify in the layout bar. See Adding and hiding fields in Table View for more information.

Was this topic helpful? Send feedback.