User manual

4
Finding records 31
Performing quick finds in Browse mode 31
Making find requests in Find mode 32
Finding text and characters 34
Finding numbers, dates, times, and timestamps 36
Finding ranges of information 37
Finding data in related fields 38
Finding empty or non-empty fields 38
Finding duplicate values 39
Finding records that match multiple criteria 39
Finding records except those matching criteria 40
Viewing, repeating, or changing the last find 41
Saving find requests 41
Deleting and reverting requests 41
Hiding records from a found set and viewing hidden records 42
Finding and replacing data 42
Sorting records 43
Previewing and printing databases 44
Previewing data on a layout 45
Printing records 45
Printing labels and envelopes 46
Printing scripts 48
Printing table and field information 48
Printing the relationships graph 49
Automating tasks with scripts 49
Backing up database files 50
Setting preferences 50
Chapter 3
Creating databases 51
Planning a database 51
Creating a FileMaker Pro file 55
Creating a file using a Starter Solution 55
Creating a new file 56
Creating and changing fields 57
About naming fields 57
About choosing a field type 58
Creating and changing fields in the Field Picker dialog box 59
Creating and changing fields in the Manage Database dialog box 61
Creating and changing fields in Table View 63
Creating calculation fields 63
Creating summary fields 65
Using supplemental fields 67
Setting options for fields 67
Defining automatic data entry 68
Defining field validation 69
About indexing and storage options 71
Creating database tables 72