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
- Performing quick finds based on data in one field
- 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
- Sharing databases on a network
- Importing and exporting data
- Saving and sending data in other formats
- Sending email messages based on record data
- Supported import/export file formats
- ODBC and JDBC
- Methods of importing data into an existing file
- About adding records
- About updating existing records
- About updating matching records
- About the importing process
- Converting a data file to a new FileMaker Pro file
- About the exporting process
- Publishing databases on the web
- Chapter 5 Protecting databases with accounts and privilege sets
- Chapter 6 Converting FileMaker databases from previous versions
- Index
110 FileMaker Pro User’s Guide
Changing
data in fields 22
find requests 32
lookups 80
preferences 38
relationships 78
Characters
maximum in fields 22
not allowed in field names 44
Checkboxes, displaying fields as 62
Clients
described 81
limits, on the web 88
performing tasks 83
saving files 81
Clones 16
Closing windows and files 16
Columnar list/report layout
See also Layouts
described 55
Columns
changing width 58
in tables 18
printing records in 57
Combo boxes, displaying fields as 62
Comma-Separated Text format 85
Compacted copies of files 16
Comparison operators 47
Container fields
See also Fields
described 45
formatting 66
Control styles for fields 62
Conversion.log file 105
Converting
multiple files 103
single files 102
version 1.x and 2.x files 106
Copying
field definitions 16
files 16
records 20
related records 21
scripts 16
Count for summary fields 48
Creating. See Adding; Defining
Cross-platform, file sharing 15
Currency, formatting 64
Current
date, formatting 64
time, formatting 65
Custom menus, FileMaker Pro Advanced 8
D
Data
described 13
entering automatically 20, 50
exporting 84
importing 84
privileges for sharing 92
view as form, list, table 18
Data entry 22, 49–51
Data Entry Only privilege set, described 93
Data types
See also Field types
and calculation results 47
Database locks. See Accounts; Privilege sets
Databases
creating 42
described 13
naming 43
planning 39
printing 35
publishing on web 88
Databases, relational. See Relational databases
Date fields
described 44
entering and editing values in 22
four-digit years 22, 51
Dates
See also Date fields
displaying calendars 62
entering data 22
finding 27
finding today’s 27
formatting 64
four-digit years, verifying 51
invalid 27
typing in 22
validating 51
dBASE file format 85
DBF format 85
Decimal numbers 64
Defining
See also Adding; Placing
accounts 96
calculation fields 46
databases 43
fields 43
lookups 79
passwords 95
privilege sets 98
summary fields 48
tables 52
value lists 62
Deleting
data 23
fields from a layout 61
find requests 32
related records 21, 78
Dictionary files, preserving during file
conversion 107
DIF format 85
Document preferences 38
Drag and drop, fields onto layout 61
Drop-down calendar 62
Drop-down lists, displaying fields as 62
Duplicate records, finding 29
Duplicating
files 16
records 20
related records 21