User manual

Contents
Preface
Introducing FileMaker Pro
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
Chapter 1
Using databases
About database fields and records 13
Opening files 14
Opening multiple windows per file 15
Closing windows and files 15
Saving files 16
When FileMaker Pro saves a file 16
About modes 17
Viewing records 17
Viewing records in table format 18
Selecting the active record 19
Moving through records 19
Adding and duplicating records 20
Adding and duplicating related records 20
Deleting records 21
Entering data 21
Selecting a field 21
Entering and changing data in fields 22
Finding records 23
Making a find request 23
Finding text and characters 24
Finding numbers, dates, times, and timestamps 25
Finding ranges of information 26
Finding data in related fields 27
Finding empty or non-empty fields 27
Finding duplicate values 27
Finding records that match multiple criteria 27
Finding records except those matching criteria 28
Deleting and reverting requests 29
Viewing, repeating, or changing the last find 29
Hiding records from a found set and viewing
hidden records 29
Finding and replacing data 30
Sorting records 30
Previewing and printing databases 31
Previewing data on a layout 31
Printing records 32
Printing scripts 33
Printing table and field information 33
Printing the relationships graph 33
Automating tasks with scripts 34
Backing up database files 34
Setting preferences 34