U.M. (Mac OS)
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
- Index
Working with information in records 4-25
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).
Repeating, editing, and deleting find requests
You can repeat the most recent find request to find records that match
the same criteria. If you add or delete records after defining the first
request, the result is a different set of found records. You may also edit
your requests before finding records again.
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 or Help menu, and then type:
E records, finding
?