User manual

Contents
Preface
Introducing FileMaker Pro 7
Using this manual 7
Using FileMaker Pro documentation 7
Where to find PDF documentation 7
Online Help 8
Templates, examples, and more information 8
Suggested reading 8
FileMaker Pro overview 9
Creating simple or complex databases 9
Using layouts to display, enter, and print data 9
Finding, sorting, and replacing data 10
Protecting databases with accounts and privilege sets 10
Creating scripts to automate tasks 10
Sharing and exchanging data 11
Saving and sending databases in other formats 11
New features 11
Information sharing features 11
Usability improvements 12
Ensure data accuracy 12
Functions and script steps 12
Chapter 1
Using databases 13
About database fields and records 13
Opening file s 14
Opening multiple windows per file 15
Closing windows and files 16
Saving files 16
When FileMaker Pro saves a file 17
About modes 17
Viewing records 18
Viewing records in table format 18
Selecting the active record 19
Moving through records 20
Adding and duplicating records 20
Adding and duplicating related records 21
Deleting records 21
Entering data 22
Selecting a field 22
Entering and changing data in fields 22
Finding records 23
Making a find request 24
Performing quick finds based on data in one field 25
Finding text and characters 25
Finding numbers, dates, times, and timestamps 26
Finding ranges of information 28
F inding data in related fields 29
Finding empty or non-empty fields 29
Finding duplicate values 29
Finding records that match multiple criteria 29
Finding records except those matching criteria 30
D eleting and reverting requests 32
Viewing, repeating, or changing the last fin d 32
Hiding records from a found set and viewing
hidden records 32
Finding and replacing data 32
Sorting records 33