Help

Creating a database
F
ILEMAKER PRO HELP 197
To change a summary field:
1. With the database open, choose File menu > Manage > Database.
2. In the Manage Database dialog box, click the Fields tab.
3. If your database contains more than one table, select the appropriate table from the Table
list.
4. In the Fields tab of the Manage Database dialog box, select the summary field, then click
Options (or double-click the field name).
5. In the Options for Summary Field dialog box, make your changes.
6. Click OK.
7. Continue making changes or click Done.
To change a summary field in Table View:
1. With the database open in Browse mode, click Table View in the layout bar.
2. Right-click the column heading for the summary field and choose Field > Field Options
from the shortcut menu.
3. In the Options for Summary Field dialog box, make the changes you want, then click OK.
Related topics
Defining summary fields
Summary data is missing or incorrect
Specifying formats for fields containing numbers
Reordering field definitions
FileMaker Pro uses the order in which fields appear in the Fields tab of the Manage Database dialog
box for all dialog boxes that list fields. You can list fields in the order they were created, by field
name, by field type, or in a custom order that you define.
To reorder field definitions:
1. With the database open, choose File menu > Manage > Database.
2. In the Manage Database dialog box, click the Fields tab.
3. If your database contains more than one table, select the appropriate table from the Table
list.
4. In the Fields tab of the Manage Database dialog box, choose the order you want from the
View by list.
To define a custom order, drag the double arrow next to the field definition to move the field
up or down in the list.
To change the Do this
Type of summary calculation Select another summary type, like Total of
Options for the summary type Select or clear options, like Running total
Field you want to group data by Select a different field name