U.M. (Windows)
Table Of Contents
- Preface: Getting help
- Chapter 1: FileMakerPro basics
- Chapter 2: Creating a database file
- Chapter 3: Laying out and arranging information
- Understanding layouts
- Working with predefined layout types
- Arranging records in columns
- Managing layouts
- Working with layout parts
- Changing layout parts
- Working with all object types
- Working with graphic objects
- Working with fields in a layout
- Adding fields to a layout
- Adding merge fields
- Deleting a field from a layout
- Defining display formats for fields
- Determining data entry in fields
- Setting the tab order for data entry
- Adding scroll bars to fields
- Formatting repeating fields
- Adding borders, fill, and baselines to fields
- Defining value lists
- Formatting fields with value lists
- Working with text
- Chapter 4: Working with information in records
- Working in Browse mode
- Adding data to a file
- Selecting a field for data entry
- Adding and duplicating records
- Entering and changing data in fields
- Working with container fields
- Entering data from a value list
- Viewing and inserting data from another source
- Copying and moving values and records
- Using drag and drop to move information
- Replacing field values
- Working with records
- Finding information
- Deleting records
- Sorting records
- Chapter 5: Using ScriptMaker and buttons
- Chapter 6: Previewing and printing information
- Chapter 7: Networking and access privileges
- Chapter 8: Importing and exporting data
- Chapter 9: Customizing FileMakerPro
- Chapter 10: Using data from related files
- Chapter 11: Publishing files on the Web
- About the World Wide Web
- About FileMaker Pro Web Companion
- Publishing your database on the Web—an overview
- Getting ready to publish your files on the Web
- Setting up FileMaker Pro Web Companion
- Configuring FileMaker Pro Web Companion
- Setting up Instant Web Publishing
- Database security
- Helping Web users find your database
- Custom Web Publishing
- Appendix A: Recovering damaged files
- Appendix B: Working with international files
- Appendix C: Summary of functions
- Appendix D: Linking and embedding objects
- Index
4-24 FileMaker Pro User’s Guide
Note For information about system formats, see appendix B, “Working
with international files.”
Finding different sets of criteria
You can find all the records in a file (for example, after you’ve created
a found set), find records that match more than one set of criteria (logical
AND search), or find records that match either one set of criteria or
another (logical OR search).
Today’s date in a date field or
calculation field that produces
a date result
// // finds April 4, 1998
(when the current date is
4/4/98)
A time in a time field or
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
Choose FileMaker Help Index from the Help menu, and then type:
E data, finding
To find Do this
All the records in a file Choose Find All from the Select menu.
A group of records that
match a specific set
of criteria
In one request, enter criteria into as many fields as needed to
make your request specific (creating a logical AND search), and
then click Find (or choose Perform Find from the Select menu). For
example, type Johnson and Personnel to find all people
named Johnson who work in Personnel.
Records that match one
criterion or another
Choose New Request from the Mode menu. (Or use the bookmark
to display the request to duplicate, and then choose Duplicate
Request from the Mode menu.) Enter or edit the criteria, continue
adding new or modified requests for each set of criteria (creating
a logical OR search), and then click Find (or choose Perform Find
from the Select menu). For example, type New York in the first
request and Paris in the second request to find all records that
contain either New York or Paris.
Choose FileMaker Help Index from the Help menu, and then type:
E records, finding
To find Type this in the field Example
?
?