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
104 FileMaker Pro User’s Guide
P
Page breaks, viewing in Preview mode 31
Page margins, displaying in Preview mode 32
Page numbers 50
viewing in Preview mode 32
Page orientation for printing 32
Parts. See Layout parts
Passwords
defining 85
protecting files with 85
related files, planning 37
troubleshooting 95, 96
Picture fields. See Container fields
Placing
fields on a layout 54
merge fields 55
related records 55
Planning
databases 35
file security 84
relational databases 35
Pointer tool. See Selection tool
Pointers to files. See Relationships
Portals
See also Relational databases
adding records 20
deleting records 21
described 63
omitting related records 29
placing related records 55
selecting 53
selecting records 19
summarizing data in 70
Preferences
application 34
described 34
file 34
Preview mode, described 17, 31
Previewing printing
See Printing
Previewing columns 51
Primary keys. See Match fields
Print area, viewing 31
Print Setup script steps, converting 97
Printing
Asian text 58
blank records 32
described 31
information about database 33
previewing 31
records 32
records in columns 51
scripts 33
setting up 32
Privilege sets
Data Entry Only 83
defining 88
described 82
Full Access 83
predefined 83
Read-Only Access 83
viewing 86
Protecting files. See Accounts; Privilege sets
Publishing, databases on the web 79, 85
Q
Quotation marks in searches 24
R
Ranges of information, finding 26
Read-Only Access privilege set, described 83
Record locking 75
Records
active 19
adding 20, 76
browsing
in a list 17
individual 17
copying 20
deleting related 21
described 14
displaying sorted related 70
duplicating 20
exporting 78
finding 23
hiding 29
locked 75
matching 77
moving to 19
omitting 28
printing in columns 51
selecting 19
sorting 25, 31
related records 70
sorting in table format 18
viewing as forms, lists, or tables 17
Related fields
See also Fields; Relational databases
calculations 42
described 63
on layouts 55
planning 37
summarizing data 70
Related files, restricting access 37
Related records
See also Records; Relational databases
adding 20, 70
copying 20
deleting 21, 70
described 63
displaying in portals 55
duplicating 20
finding and omitting 27
sorting 70
summarizing data 70
Related tables
described 63
planning 35
Relational databases
described 14, 61