User manual

3-4 FileMaker Pro User’s Guide
Note System formats is documented in Help. Choose Help menu >
Contents and Index, click the Index tab, and type system formats.
Finding ranges of information
Finding data in related fields
You can enter Find criteria in related fields that are displayed in a
portal or directly on a layout.
When you perform a Find in a related field, FileMaker Pro displays
all records in the master file that have a related record matching the
criteria entered in the related field.
For example, suppose you have an invoice file with a portal
displaying line items. To find all invoices listing a Computer, type
Computer in the Item field in the portal. For more information about
related fields, see chapter 8, “Working with related files.”
A Boolean number in a
number field or in a
calculation field that
produces a Boolean
result
True, Yes, Y, y, T,
t, or 1 to find True
values
False, No, N, n, F,
f, or 0 to find False
values
T finds True, Yes, Y, y, T, t,
and 1
0 finds False, No, N, n, F, f,
and 0
A date in a date field or
in a calculation field that
produces a date result
The date as digits,
separated by a
nonnumeric character, in
the format used when the
file was created (unless
Use System Formats is
chosen)
3/3/2000 finds
3/3/2000,
March 3, 2000, and
3-3-2000
Today’s date in a date
field or in a calculation
field that produces a date
result
// // finds April 4, 2000
(when the current date is
4/4/2000)
A time in a time field or
in a calculation field that
produces a time result
The time as digits,
separated by colons, in
the format used when the
file was created (unless
Use System Formats is
chosen)
12:53:09 finds 12:53:09
Invalid dates, times, or
calculated date or time
results
? ? finds:
Next Tuesday or 2/33/2000
in a date field, or midnight
in a time field
Ranges of information See the next section.
To find Type this in the field Example
To find values that are
Use this
operator
Example
Less than a specified value. < <40
<9/7/1999
<M
Less than or equal to a specified
value.
<=
or ≤ (Mac OS)
<=95129
≤05:00:00
<=M
Greater than a specified value. > >95129
>9/7/1999
>M
Greater than or equal to a specified
value.
>=
or ≥ (Mac OS)
>=100
>=9/7/1999
≥8:00
≥M
Within the range you specify. A
range is first to last character in the
alphabet for text; least to greatest for
numbers; and earliest to latest for
date and time.
.. or ...
(two or three
periods)
12:30...17:30
1/1/1999..6/6/
2000
A...M