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
Working with information in records 4-23
Keep these points in mind:
1 Searching for literal text takes longer than word searches. (See
“Indexing fields” on page 2-11.)
1 You can omit records when you define one or multiple requests. See
“Omitting records” on page 4-25.
Finding numbers, dates, and times
Whole words of literal text
(text exactly as it appears, but
regardless of uppercase or
lowercase)
Choose Literal text from the
Symbols list. Type the text,
including spaces and
punctuation, surrounded by
double quotation marks (").
"Marten and Jones
Interiors" finds Marten
and Jones Interiors but not
Jones and Marten Interiors
Partial words of literal text
(text exactly as it appears, but
regardless of uppercase or
lowercase)
Choose Literal text from the
Symbols list. Type
characters, punctuation, and
spaces exactly as they appear
in the file, surrounded by
double-quotation marks (").
Type the wildcard character
(*) to find text in the middle
of the literal text string.
*"son & Phillips" finds
Johnson & Phillips and
Paulson & Phillips
", " finds Boston, MA and
Markley Insurance, Inc.
Choose FileMaker Help Index from the Help menu, and then type:
E symbols
To find Type this in the field Example
A number in a number field or
calculation field that produces
a numeric result
The number, in the format used
when the file was created
(unless Use System Formats is
chosen)
.50 finds .50, $.50,
and 50%
A Boolean number in a
number field or calculation
field that produces a Boolean
result
The value you’re using for
the field
Y, y, t, and T find Yes
1 finds 1
F, f, n, and N find
False
A date in a date field or
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/98 finds 3/3/98,
March 3, 1998, and
3/3/1998
To find this in a text field Type this in the field Example
?