Using a field indexFileMaker Pro can create an index of values for each text, number, date, time, timestamp, and calculation field. You can view the values in the index, and insert them into a field to prevent typing values incorrectly.Note To use index values, indexing options must be enabled for the field. See Defining field indexing options.
1.
2.
•
• You can enter two or more words in a field and have them treated as one word by the index. For example, you may want a name like Jean Louis to appear as one word in the View Index dialog box, even when Show individual words is selected. To have two or more words treated as one, enter the space between words by pressing Ctrl+Space bar (Windows) or Option-Space bar (OS X) instead of the Space bar alone.
• For a text field, FileMaker Pro sorts the value index according to the index order of the field’s default language. If you want to display the values in a specific language’s dictionary sort order, select Re-sort values based on and choose a language. Note that the re-sorted index lasts only while the View Index dialog box is displayed. The next time you access this dialog box, values will be displayed in the original order. For more information, see Choosing a language for indexing or sorting.