User manual
Table Of Contents
- Preface Introducing FileMaker Pro
- Chapter 1 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
- 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
- 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 2 Creating databases
- Chapter 3 Working with related tables and files
- Chapter 4 Sharing and exchanging data
- Chapter 5 Protecting databases with accounts and privilege sets
- Chapter 6 Converting FileMaker databases from previous versions
- Index
98 FileMaker Pro User’s Guide
Find requests for Boolean information are also more restrictive. For
example, in a previous release of FileMaker Pro, a find request in a
number field for
True would find the values 1, True, Yes, Y, y, T,
or t. In FileMaker Pro 7, this find request would only find the value
True. You can modify your find request to make the found set match
what was returned in previous releases. You can also use the
Find/
Replace
command to make your data consistent.
File references
A file reference stores the paths that FileMaker Pro searches to
access an external file. File references are present but not visible in
previous versions of FileMaker Pro, but in FileMaker Pro 7 you can
view and edit them in the Define File References dialog box.
The following are two file reference conversion issues that may
occur:
1 After conversion of a multi-file solution, the files open very
slowly. It’s possible that file references are pointing to external
locations. You can increase the speed with which files open by
resetting file references to local paths, if possible. Also look for file
references that contain asterisks in the path, which indicates that the
file reference is searching your network for the file. Replace the
asterisk with an IP Address or domain name of the computer on
which the remote file resides.
1 After conversion, the Define File References dialog box
contains multiple versions of the same file reference. You can
manually consolidate the file references if you want. The most
efficient way to do this is to create a new file reference and then edit
relationships, scripts, value lists, and any other items that may refer
to that file to use the new file reference. Then delete all of the old file
references that are identical to it.