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
- Quick Reference
4-20 FileMaker Pro User’s Guide
You can’t enter search criteria in container fields, summary fields, or
global fields.
See the following sections for more information about search criteria.
To find values that are
Use this
operator
For example, enter
this in the field
Less than the value to the right of the
symbol
< <40
<9/7/1998
Less than or equal to the value to the right
of the symbol
<= <=95129
<=05:00:00
Greater than the value to the right of
the symbol
> >95129
>9/7/1998
Greater than or equal to the value to the
right of the symbol
>= >=100
>=9/7/1998
Exactly as you specify, although the field
may contain other values (additional words,
for example)
= =John
Exactly as you specify, in the order you
specify, and the field contains no other
values
== ==John
Within the range you specify.
A range is first to last character in the
alphabet for text; least to greatest for
numeric; and earliest to latest for date
and time.
... (three periods)
or
.. (two periods)
12:30...17:30
1/1/98..6/6/98
Duplicate values (for example, to examine
duplicate records in a mailing list)
! !
Today’s date // //
Invalid dates, times, or calculated results ? ?
One unknown or variable text character @ @on
Zero or more unknown or variable
text characters
* J*n
In fields (to find fields that contain values) * *
Literal text (text exactly as it appears, but
regardless of uppercase or lowercase) in a
text field
" " " "
", Ltd."
Empty fields (for example, to find records
of unfilled orders)
= =