
Finding and selecting records in FileMaker Pro
When navigating in a FileMaker database and entering or changing data, the user is in browse mode. FileMaker distinguishes between four modes, which can be changed in the menu bar under "View".
- Browse mode for navigating and editing data records
- Search mode to find or select data records
- Layout mode to change the currently selected layout
- Side view mode shows how the currently called layout would look on a page or as print output
To find or select data records in FileMaker, the Search mode via the menu bar or the key combination [Cmd-F] or [Ctrl-F] under Windows. The fields now appear with a dashed frame, which indicates to the user that they are in Find mode. FileMaker supports searching in any field, i.e. selections can be made across all fields on the layout.

Multiple queries for multiple options with the same criteria
The key combination [Cmd-N] or the menu command [Records > New query] can be used to create another query for the current search query. This is necessary if several options are to be selected from the same criteria. For example, if you have a field that contains the entries "Customer", "Supplier", "Prospective customer" and "Trade fair visitor", but you only want to select the customers and suppliers, create your first search query for the customers and the second search query with the suppliers and select the customers in the field in the first query and the suppliers in the second query. Both queries are now carried out in the search result and the respective search results are added to the data records called up afterwards.
In the following overview you will find a list of the search options in FileMaker fields:
Search in text fields
Search for text or text passages in text fields. Unless you are searching for word combinations and exact matches, the field found may contain not only the specified text, but other values in any order. For example, if you enter "Hotel" in the "Company" field, FileMaker will find records for "Hotel", "Wellness Hotel" and "Hotel & Restaurant".
Words that begin with certain characters:
Chris Meyer
...finds Chris Meyer, Chris Meyerdierks and Meyer Christiane.
An exact phrase or character string
"Restaurant Strohhalm"
...finds only "Restaurant Strohhalm"
Words with an unknown sign:
F@au
...finds woman and flat.
Invalid characters
? (question mark)
...finds invalid characters, even in a date or number field
Several unknown characters:
eggs
...finds iron, ice skating and ironworkers.
Digits in a text field
# (for each digit)
...finds 5, but not 50
Parts of a phrase (a string of words or characters):
*"er & Schmidt"
...finds "Meyer & Schmidt", but also "Müller & Schmidt".
Exact match:
== (two equal signs)
==Stefanie
...finds Stefanie, but not Stefanie Meyer.
Exact match with the given whole words:
= (an equals sign)
=Annett =Meyer
...finds Annett Meyer or Meyer Annett, but not Annett or Annette Meyer.
Search in number and date fields
A number in a number field
0,50
...finds 0.50 and 50%.
A value range in a number field
8...50
...finds all values between 8 and 50.
A date in a date field
3.3.2005
...takes place 3.3.2005, March 3, 2005 and 03-03.2005.
A time period in a date field
3.3.2011...31.12.2011
...finds all data records with a date between 3.3.2011 and 31.12.2011.
Today's date in a date field
// (two dashes)
...finds today's (system) date
Date values on a specific day of the week in a date field
Tuesday
...finds all entries that fall on a Tuesday
All valid values for a date or time field
* (asterisk) ...finds all valid values
Invalid dates
? (question mark)
...finds invalid entries, see above
All of the above search options can be used in time or time stamp fields in the same way as the date fields.
Almost all desired search queries and selections can be carried out successfully with the search options mentioned. While the search mode is active, there are further practical commands for working in search mode in the menu bar. In addition to creating new queries, queries can be duplicated or removed here, the search process can be started and result sets can be restricted or expanded. The status bar contains a [none] button that can be used to negate the current search query. It also contains a pop-up menu with special characters frequently used for search queries.

Markus Schall has been developing individual databases, interfaces and business applications based on Claris FileMaker since 1994. He is a Claris partner, FMM Award winner 2011 and developer of the ERP software gFM-Business. He is also a book author and founder of the M. Schall Publishers.
