Defining repeating fields
You can store more than one value in a text, number, date, time, container, calculation, or global field by making the field a repeating field.
For example, you can create a text field named Color that stores the colors available for each product you sell. If you make Color a repeating field, you can enter all the colors for each product into the Color field.
Note  Instead of using a repeating field, it is often easier to use a related table and a portal to sort or insert data, or create a summary report.
To define a repeating field:
1.
With the database open, choose File menu > Manage > Database.
Note  To set options for fields in Table View, right-click the column heading for the field, choose Field > Field Options from the shortcut menu, then skip to step 6.
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.
Select the field you want to repeat, or define a new field.
5.
Click Options (or double-click the field name).
6.
In the Options for Field dialog box, click the Storage tab.
7.
In the Repeating area, enter a number for Maximum number of repetitions.
If the field is a calculation field, you see the Specify Calculation dialog box instead of the Options for Field dialog box. For Number of repetitions, enter the number of repetitions (up to 32,000).
8.
Click OK to close the Options for Field dialog box, or click another tab to set additional field options.
9.
Click OK.
Notes
 •
Use the Data tab of the Inspector to change the number of repetitions displayed on a layout.
 •
In a repeating field, there's a separate display area for each repetition. If you define a field to repeat, all repetitions have the same size and other field characteristics.
 •
Some FileMaker Pro features (like calculation and summary fields, and find requests) include all the values in a repeating field. For example, when you create a find request, FileMaker Pro searches for values in all repetitions, even those that aren't visible in the current layout. Other FileMaker Pro features, like sorting, only use the first value in a repeating field. For information about how a feature works with repeating fields, see the Help topic for that feature.
 •
Values in a repeating field cannot be easily summarized to create a report. You can, however, define a calculation that uses an aggregate function, which is similar to summarizing data on a record-by-record basis.
Related topics 
Getting the contents of a repetition in a repeating field
Setting up the display of repeating fields
Was this topic helpful? Send feedback.