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
100 FileMaker Pro User’s Guide
Changing
data in fields 22
find requests 29
lookups 72
preferences 34
relationships 69
Characters
maximum in fields 22
not allowed in field names 39
Clients
described 73
limits, on the web 79
performing tasks 75
saving files 73
Clones 16
Closing windows and files 15
Columnar list/report layout
See also Layouts
described 49
Columns
changing width 52
in tables 18
printing records in 51
Comma-Separated Text format 76
Committing data 16
Compacted copies of files 16
Comparison operators 42
Container fields
See also Fields
described 40
formatting 58
Conversion.log file 95
Converting
multiple files 93
single files 92
version 1.x and 2.x files 96
Copying
field definitions 16
files 16
records 20
related records 20
scripts 16
Count for summary fields 43
Creating. See Adding; Defining
Cross-platform, file sharing 15
Currency, formatting 56
Current
date, formatting 57
time, formatting 57
D
Data
committing 16
described 13
entering automatically 20, 45
exporting 76
importing 76
view as form, list, table 17
Data entry 44–47
Data Entry Only privilege set, described 83
Data types
See also Field types
and calculation results 43
Database locks. See Accounts; Privilege sets
Databases
described 13
naming 38
planning 35
printing 32
publishing on web 79
relational 14
Databases, relational. See Relational databases
Date fields
described 40
entering and editing values in 22
four-digit years 22, 46
Dates
See also Date fields
entering data 22
finding 26
finding today’s 26
formatting 57
four-digit years, verifying 46
invalid 26
typing in 22
validating 46
dBASE file format 76
DBF format 76
Decimal numbers 56
Defining
See also Adding; Placing
accounts 86
calculation fields 41
databases 39
fields 39
lookups 71
passwords 85
privilege sets 88
summary fields 43
tables 47
Deleting
data 22
fields from a layout 55
find requests 29
related records 21, 70
Designing databases
planning 35
relational 35
Dictionary files, preserving during file
conversion 96
DIF format 76
Document preferences 34
Drag and drop, fields onto layout 54
Duplicate records, finding 27
Duplicating
files 16
records 20
related records 20
E
Electronic documentation 7
Elements. See Objects