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
116 FileMaker Pro User’s Guide
Symbols
and field names 44
finding 25
Symbols pop-up menu 24
T
Tab controls
described 53
including in tab order 22
Tab order 22
Table view, described 56
Tables
defining 52
described 13
importing data into new 85
naming 53
table occurrences 72
viewing records as 18
Tabs, inserting in fields 23
Tab-Separated Text format 85
Tagged PDF files 7
Templates
creating files 42
described 7, 42
Text
See also Fields
attributes 64
fields 44
finding 26
formatting 64
rotating Asian text 66
selecting 59
Text fields
described 44
entering and editing values in 22
Text notes, in relationships graph 77
Time fields
described 44
entering and editing values in 23
Times
finding 27
formatting 65
invalid 27
Timestamp fields
described 44
entering and editing values in 23
four-digit years 23
Timestamps, formatting 65
Title headers and footers, described 68
Today’s date, finding 27
Tools
described 59
field tool 61
selection tool 59
Tooltips, FileMaker Pro Advanced 8
Total for summary fields 48
Trigger fields. See Match fields
True result 26, 44, 51, 64, 108
Type-ahead feature 62
U
Unauthorized users. See Accounts; Privilege sets
Unstored results 52
Updating existing data during import 86
Upgrading files 101
URLs, opening 89
User dictionaries, preserving during file
conversion 107
V
Validating field values 50
Value lists 49, 83
described 62
Values
See also Field values
finding duplicates 29
finding exact 26
Variables
in file paths 12
script step 12
symbols for 44
Vertical writing 66
View as Form, described 18
View as List, described 18
View as Table, described 18
Viewing
accounts 96
extended privileges 99
page breaks and page numbers in Preview
mode 35
print area 35
privilege sets 96
records as forms, lists, or tables 18
Virtual results 52
W
Web
field name considerations 44
hosting databases on 89
Wildcards in searches 25
Windows
closing 16
displaying only from current file 12
opening multiple 15
Select Window script step 12, 108
Windows Domain 97
WK1 format 85
WKS format 85
Workgroups, sharing files 88
World Wide Web. See Web
X
XML
importing and exporting to 85
privileges for 92, 98
XML format 85
XSLT
privileges for 92, 98
Y
Y2K, year validation 50, 51
Years
four-digit in Date fields 22, 51
four-digit in Timestamp fields 23