Help

Creating a database
F
ILEMAKER PRO HELP 186
To set indexing options for a 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. Click the field name.
5. Click Options (or double-click the field name).
6. In the Options for Field dialog box, click the Storage tab.
If you selected a calculation field, you see the Specify Calculation dialog box. Click Storage
Options.
7. Select indexing options for the field.
8. For calculation fields, select Do not store calculation results if you want FileMaker Pro to
calculate the result only when needed, then click OK.
9. Click OK to close the Options for Field dialog box, or click another tab to set additional field
options.
Notes
• You can define storage and indexing options for text, number, date, time, and timestamp
fields. You can also index calculation fields if the results are text, number, date, time, or
timestamp.
• FileMaker Pro stores most calculation field values immediately after the field is defined,
when the Manage Database dialog box is closed. By default, calculations that include a
related field, summary field, global field, or a reference to another unstored calculation are
unstored; all other calculations are stored.
• Stored results require more disk space. Unstored results require more time to calculate.
• For normal use, use None or Minimal and enable the option to Automatically create
indexes as needed.
Select To
None Prevent FileMaker Pro from indexing the field.
Minimal Create a value index of a text field’s contents or a calculation
field returning text results.
All Create both word and value indexes for text fields or calculation
fields returning text results. For number, date, time, and
timestamp fields, as well as calculation fields returning results of
these types, All creates an index of a field's values.
Automatically create indexes as
needed
Create the necessary index only if a user performs a search
using the field or if the field is used as a
match field in a
relationship.
A language from the Default
language list
Specify the language used for indexing and sorting values in a
text field. Each language is tailored to support language-specific
indexing and sorting requirements.