U.M. (Mac OS)

Creating a database file 2-11
Defining repeating fields
A repeating field holds more than one value (up to 1000), each in a
separate repetition (row) of a field of any type except summary. For
example, use a repeating field to show all available tours for a cruise
line.
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-72.
Choose FileMaker Help Index from the or Help menu, and then type:
E repeating fields
Each value in a repeating field
is a single, separate value