Help

Finding, sorting, and replacing data
F
ILEMAKER PRO HELP 123
Example
To first search for customers in New York, and then broaden the search to also include customers in
Hong Kong:
1. Perform a find for New York in the City field.
2. Go to Find mode and enter a second find request: type Hong Kong in the City field.
3. Instead of clicking Find, choose Requests menu > Extend Found Set.
The found set would then consist of customers in both New York and Hong Kong.
Related topics
Constraining (narrowing) a found set
Finding duplicate values
Finding records based on criteria in a single field
Finding records troubleshooting
Can’t click into a field to enter find criteria
• Finds cannot be made on summary fields, container fields, or fields defined with the global
storage option.
• See also Can't click or tab into a field.
Can’t find records
• Check your spelling carefully.
• Use the index to enter criteria accurately.
• Data is entered into the wrong field type.
• A range was entered backward; it must be smallest to largest.
• If a field is formatted to display as checkboxes or radio buttons, some values in the field
might not be visible. For example, if the value list item was changed from Jr to Junior, any
records entered under Jr will not be found by clicking the Junior checkbox/radio button. To
find all possible values in a field, use a copy of the field that is not formatted to use a value
list or radio buttons, and enter find criteria into this field.
Finding records that shouldn't be included
• More than one value is in the field and you can’t see it. Click in the field to see all the data
the field holds.
• Words in your find criteria are too long to be indexed (for example, a long chemical formula).
FileMaker
Pro indexes the first 100 characters of each word in a text field, including spaces.
Finding the wrong records
• See also the previous two items.
• If finding in portals, see Finding data in related fields.
• In most finds using Omit, define Omit requests last. (First include all the records you want to
select from, then exclude undesired records from the group.)
• See Finding duplicate values.