U.M. (Windows)

Creating a database file 2-11
You can use repeating fields for calculating values and finding and
sorting records. FileMaker Pro includes all values in a repeating field for
calculations, summaries, and find requests, even those that aren’t visible
in the current layout. For sorting, FileMaker Pro uses only the first value
in a repeating field.
You can make a calculated field repeating when you define a
calculation. (See “Writing formulas for calculation fields” on page
2-20.) You can make a global field repeating when you choose global
field options. (See “Defining global fields” on page 2-9.)
To define a text, number, date, time, or container field to be repeating:
1. Create a file, or, in Browse or Layout mode, choose Define from the
File menu and then choose Fields.
2. In the Define Fields dialog box, double-click the name of the field to
be repeating.
3. In the Entry Options dialog box, select Repeating field with a maximum
of
n repetitions, and then type the number of repetitions you want.
4. Click OK, and then click Done.
To change the number of repetitions visible on a layout, see
“Formatting repeating fields” on page 3-71.
Indexing fields
FileMaker Pro indexes each value in fields used for these tasks (unless
you deselect the automatic index option):
1 validating fields with unique or existing validation criteria
1 matching fields in a related or lookup file
1 matching fields in a master file (to find data in a field based on
the relationship)
Choose FileMaker Help Index from the Help menu, and then type:
E repeating fields
Each value in a repeating field
is a single, separate value
?