Functions Reference

Table Of Contents
Appendix A
|
Glossary 233
Subsummary parts
Use summary parts to view and display information from one or more records. You place
a summary field in a summary part to display a summary of information for each group of
records sorted on the break field. You can add one or more subsummaries above
(leading) or below (trailing) the body.
Subsummary value
Aggregate values for different categories of data within a field. For example, a
subsummary value can be the total of employees for each department.
Summary field
A field that contains the result of a summary calculation of values across a group of
records.
Supplemental field
A FileMaker calculation field or summary field that you can append to ODBC tables in
order to do calculations on the external data while working in FileMaker. The calculations
are not stored and you are not changing the schema of the ODBC table.
System formats
Settings you control with control panels to determine how dates, times, currency, and
numbers display and sort on your computer. (See the documentation that came with your
computer for information on using these control panels.)
If the system formats are different on your computer from the ones on the computer where
the database file was created, the first time you open the file, FileMaker Pro will ask you
if you want to use the system’s settings or the file’s settings.
T
T square
Nonprinting, movable horizontal and vertical guidelines to help you position and align
objects in Layout mode. An object's left or right boundary, top or bottom boundary, or
center "snaps to" the T square lines.
Tab control
A layout object made up of one or more tab panels that allows you to organize fields and
other objects within each tab panel's borders.
Tab order
The order in which you move from field to field in a record. In Layout mode, you can define
a custom tab order and include buttons, tab controls, and web viewers in the tab order.