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
Index 101
Empty or non-empty fields 27
Encryption. See Accounts; Privilege sets
Entering data
automatically 45
Furigana 41
typing in fields 22
Envelope layout
See also Layouts
described 51
Excel format 76
Exchanging files
exporting 76, 78
importing 76
relational databases 61
with other applications 76
Exporting
See also Exchanging files
described 76
file formats 76
formatting 78
Extended columnar layout. See Columnar list/
report layout
Extended privileges
described 82
viewing 89
External Server account 82, 88
F
False result 26, 40, 46, 56, 97
Field behavior 59
Field definitions
copying 16
creating 39
Field labels 55
Field names 39
Field rights. See Accounts; Privilege sets
Field tool 54
Field types
and calculation results 43
described 40
Field values
deleting 22
described 14
entering and editing 22
entering automatically 45
finding and replacing 30
prohibiting change 45
Fields
See also Calculation fields; Container
fields; Date fields; Match fields;
Number fields; Related fields; Summary
fields; Text; Time fields; Timestamp
fields
adding to a layout 54
defining 39
deleting from a layout 55
described 13
displaying 9, 48
empty or non-empty, finding 27
entry options 44
formatting 56
Furigana in 41
global 47
indexing 47
maximum characters in 22
merge 55
naming 39, 41
options 41
placing on a layout 54
removing from a layout 55
restricting data entry 59
selecting 21, 53
stored and unstored results 47
types 40
typing in 22
validation options 46
File
options 34
preferences 34
File formats, import/export 76
File references 15, 75, 84, 98
File sharing, enabling 74
FileMaker Pro
documentation information 7
file format 76
product overview 9
versions 1.x and 2.x 96
FileMaker Server 73, 79, 87
Filename extensions
for converted files 92, 94
fp7 15
Files
accounts 82
backing up 34
cloning 16
closing 15
converting 91
copying 16
creating 38
described 14
duplicating 16
exporting to 78
opening 14
opening across platforms 15
planning 35
privilege sets 82
protecting 81
remote 14
saving 16
shared 84
on web 79
templates
creating files 38
described 38
Find mode, described 17
Find requests
See also Finding records
adding new 28
broadening criteria 28
deleting 29
described 23
editing 29