Help

Adding and viewing data
F
ILEMAKER PRO HELP 67
A new row in the beginning of the table (for leading) or at the end of the table (for trailing)
displays the subtotal for the field.
If you have also added leading or trailing groups to the table, the group summary rows also
display the subtotal for each group for the specified field. You have to choose a leading subtotal
to display subtotals for leading groups and a trailing subtotal to display subtotals for trailing
groups.
3. (Optional) To change the color of the row that displays the subtotal for the field, right-click
the left or right margin of the row, then choose a color from the Part Color shortcut menu.
Notes
• Creating subtotals in Table View creates a summary field for each subtotal.
• You need to have Full Access privilege set to create summary fields in Table View. If you
don’t have Full Access privilege set, only existing summary fields are available in the
shortcut menu.
To remove subtotals from Table View:
1. In Browse mode, right-click the column heading of the field that displays subtotals and
choose Leading Subtotals or Trailing Subtotals.
2. Deselect any options that you want to remove from the Leading Subtotals or Trailing
Subtotals shortcut menu.
Note Removing subtotals from Table View does not remove the subtotal summary fields from
the database. To remove the summary fields from the database, choose File menu
> Manage >
Database, click Fields, then choose the summary fields to remove and click Delete.
To display grand totals:
1. First group and subtotal data as described earlier in this topic.
2. In Browse mode, right-click the column heading of the field containing subtotals.
3. Choose Add Leading Grand Summary or Add Trailing Grand Summary.
A new row in the beginning of the table (for leading) or at the end of the table (for trailing)
displays the grand total for the field.
4. (Optional) To change the color of the row that displays the grand total for the field, right-click
the left or right margin of the row, then choose a color from the Part Color shortcut menu.
To remove grand totals from Table View:
In Browse mode, right-click the column heading of the field that displays grand totals and choose
Remove Leading Grand Summary by <field name> or Remove Trailing Grand Summary by
<field name>.
Adding, duplicating, and deleting records
You can add, duplicate, and, delete records in Browse mode.
Adding and duplicating records
You can add and duplicate records in Browse mode.