User manual
Table Of Contents
- Chapter 1 Introducing FileMaker Pro
- Chapter 2 Using databases
- About database fields and records
- Opening files
- Opening multiple windows per file
- Closing windows and files
- Saving files
- About modes
- Viewing records
- Adding and duplicating records
- Deleting records
- Entering data
- Finding records
- Making a find request
- Performing quick finds based on data in one field
- Finding text and characters
- Finding numbers, dates, times, and timestamps
- Finding ranges of information
- Finding data in related fields
- Finding empty or non-empty fields
- Finding duplicate values
- Finding records that match multiple criteria
- Finding records except those matching criteria
- Saving find requests
- Deleting and reverting requests
- Viewing, repeating, or changing the last find
- Hiding records from a found set and viewing hidden records
- Finding and replacing data
- Sorting records
- Previewing and printing databases
- Automating tasks with scripts
- Backing up database files
- Setting preferences
- Chapter 3 Creating databases
- Planning a database
- Creating a FileMaker Pro file
- Defining database fields
- Using supplemental fields
- Setting options for fields
- Defining database tables
- Creating layouts and reports
- Setting up a layout to print records in columns
- Working with objects on a layout
- Working with fields on a layout
- Working with parts on a layout
- Chapter 4 Working with related tables and files
- Chapter 5 Sharing and exchanging data
- Sharing databases on a network
- Importing and exporting data
- Saving and sending data in other formats
- Sending email messages based on record data
- Supported import/export file formats
- ODBC and JDBC
- Methods of importing data into an existing file
- About adding records
- About updating existing records
- About updating matching records
- About the importing process
- Converting a data file to a new FileMaker Pro file
- About the exporting process
- Working with external data sources
- Publishing databases on the web
- Chapter 6 Protecting databases with accounts and privilege sets
- Chapter 7 Converting databases from FileMaker Pro 6 and earlier
- Chapter 8 Security measures
- Index
56 | Using databases
Finding and replacing data
As in a word processing application, you can find and replace data across
multiple fields (including related fields) in a record or in a find request, across
a found set of records or find requests, or across text objects in a layout. You
can search for data in any type of field except container fields and fields that are
not modifiable.
If you have added a tab control to a layout, when you find and replace data in
Browse and Find modes, FileMaker
Pro only finds and replaces data in the tab
panel that is in front. In Layout mode, FileMaker
Pro finds and replaces data in
all tab panels.
1. In Browse, Find, or Layout mode, choose Edit menu > Find/Replace >
Find/Replace.
2. In the Find what box, type the data you want to search for. In the Replace
with box, type the replacement data.
You can’t replace data in fields that are formatted as pop-up menus, radio
buttons, or checkboxes. These fields will be counted and reported as
skipped at the end of a Replace all operation.
View the omitted set Click Show All in the status toolbar.
Bring back all the records
in the file
Choose Records menu (Browse mode) or Requests menu
(Find mode)
> Show All Records.
To Do this
φμπ10_υσερσ_γυιδε.βοοκ Παγε 56 Μονδαψ, Αυγυστ 25, 2008 3:59 ΠΜ