User manual

Chapter 1
|
Using databases 23
Finding records
To find records, work in Find mode. You type criteria (the value or
values to find) into fields in a
find request, which looks like a blank
record. When you perform a find, FileMaker Pro searches through all
the records in a table, comparing the criteria you specify with the data
in the table. Records with data matching the criteria become the
found
set
, which is the subset of records being browsed. Records that don’t
match are omitted. You can constrain (narrow) or extend (broaden) the
found set.
You can work with just the records in the found set. For example, you
can view, edit, calculate summaries for, sort, print, delete, export, or
replace data in these records. You can also open a new window in order
to perform different find requests on the same data.
You can’t perform a find in summary fields, container fields, or fields
defined with the global storage option.
Enter data in a time field Type the time of day (or time duration) as:
1 hours
1 hours and minutes
1 hours, minutes, and seconds
1 hours, minutes, seconds, and fractional
seconds
Separate hours, minutes, and seconds by a
nonnumeric character like : (colon).
Separate fractional seconds by a . (period).
Type the time of day in 24- or 12-hour format,
with or without AM or PM. (AM is assumed
for a time less than 12:00.)
Enter the current time in a time,
number, or text field
Choose Insert menu > Current Time.
Enter data in a timestamp field Type the date and time (for example,
10/15/2005 3:15:05 PM). Type the day, month,
and four-digit year as numbers, separated by a
nonnumeric character like - (minus) or /
(forward slash).
Note You cannot use a : (colon) as a date
separator.
Then type the time of day as:
1 hours and minutes
1 hours, minutes, and seconds
1 hours, minutes, seconds, and fractional
seconds
1 Type AM or PM if the time is not in 24-hour
format
Separate hours, minutes, and seconds by a
nonnumeric character like : (colon).
Enter the current date and time
in a timestamp field
Choose Insert menu > Current Time.
Select the date using the drop-down calendar,
if available.
To Click in the field in Browse mode, then
Insert a tab character in a field Click where you want to insert the tab. Press
Ctrl+Tab (Windows) or Option-Tab
(Mac OS).
Delete data from a field Select the data, then press Backspace or
Delete.
Add data to a container field For information, see Help.
Insert a file in a container field For information, see Help.
Add data to value lists (fields
formatted as radio or option
buttons, checkboxes, lists, or
menus)
For information, see “Setting up checkbox sets
and other controls on a layout” on page 62.
Edit, format, or check the
spelling of text in a field or edit
dictionaries
For information, see Help.
To Click in the field in Browse mode, then