User manual
Table Of Contents
- Preface Learning how to use FileMakerPro
 - Chapter 1 FileMaker Pro basics
 - Chapter 2 Adding and viewing data
 - Chapter 3 Finding and sorting information
- Finding records
- Finding text and characters
 - Finding exact matches in text fields
 - Finding numbers, dates, and times
 - Finding ranges of information
 - Finding data in related fields
 - Finding records that match multiple criteria
 - Finding empty or non-empty fields
 - Finding duplicates
 - Finding all records except those matching criteria
 - Hiding records from a found set and viewing hidden records
 - Viewing, repeating, or changing the last find
 
 - Sorting records
 
 - Finding records
 - Chapter 4 Previewing and printing information
 - Chapter 5 Creating a database
 - Chapter 6 Creating and managing layouts and reports
 - Chapter 7 Customizing layouts
 - Chapter 8 Working with related files
 - Chapter 9 Protecting databases with passwords and groups
 - Chapter 10 Creating scripts to automate tasks
- About scripts
 - Creating scripts: an overview
 - About ScriptMaker steps
 - Control script steps
 - Navigation script steps
 - Sort, find, and print script steps
 - Editing script steps
 - Fields script steps
 - Records script steps
 - Windows script steps
 - Files script steps
 - Spelling script steps
 - Open Menu Item script steps
 - Miscellaneous script steps
 - Changing scripts
 - Duplicating, renaming, or deleting scripts
 - Importing scripts
 - Listing scripts in the Scripts menu
 - Using buttons with scripts
 - Example of a ScriptMaker script
 
 - Chapter 11 Using formulas and functions
 - Chapter 12 Importing and exporting data
 - Chapter 13 Sharing databases on a network
 - Chapter 14 Publishing databases on the Web
- About publishing databases on the Web
 - How users work with databases on the Web
 - What you need to publish databasesontheWeb
 - Publishing databases on the Web: an overview
 - Enabling FileMaker Pro Web Companion
 - Configuring FileMaker Pro WebCompanion
 - Enabling Web Companion sharing
 - Setting up browser views
 - Testing your published database
 - About browser views for web publishing
 
 - Chapter 15 Using ODBC with FileMakerPro
 - Appendix A Customizing FileMaker Pro
 - Appendix B Backing up and recovering files
 - Appendix C FileMaker Pro Quick Reference (Windows)
 - Appendix D FileMaker Pro Quick Reference (Mac OS)
 - Index
 
Index 
I-3
exporting 12-1
file sharing 1-6, 13-1
importing 12-1
Crystal Reports 15-2
Currency
exporting formats 12-7
formatting 6-22
Current
date
formatting 6-24
in calculations 11-7, 11-11
inserting on layout 7-11
pasting into fields 2-10
field 2-6
record 2-3
time
formatting 6-24
in calculations 11-12
inserting on layout 7-11
pasting into fields 2-10
user name
inserting on layout 7-11
pasting into fields 2-10
setting A-2
Current file. See Files; Master file
Custom
field values 7-4
line spacing 7-13
order, sort by value list 3-8
Custom Web Publishing, 
described 14-3
Customer support ix
Customizing FileMaker Pro. See 
Preferences
Cutting
objects 6-13
text 2-14
D
Data
described 1-1
entering automatically 2-5, 
5-8
from other files 8-1
ODBC 15-1
relationships 8-10
saving automatically A-3
view as form, list, table 2-2
Data Access Companion 15-1
enabling 15-2
Data entry 5-8–5-11
access privileges 9-1
exporting 12-1
importing 12-1
tab order 7-8
Data source, ODBC 15-1
connecting to 15-6
Data types
See also Field types
and calculation results 5-6, 
11-1
for global fields 5-8
Database files. See Files
Database locks. See Access 
privileges
Database system 1-1
Databases
described 1-1
planning 5-1
publishing on Web 14-1
Databases, relational. See 
Relational databases
Date
See also Dates; Fields
fields 5-4
finding today’s 3-4
functions 11-7
symbol, formatting 6-24
Date fields
4-digit years 1-7, 5-10
described 5-4
typing values in 2-7
Dates
See also Date; Date fields
current
formatting 6-24
in calculations 11-7, 11-11
pasting into fields 2-10
entering data 2-7
finding 3-4
formatting 6-23
in calculations 11-7, 11-11
inserting on layout 7-11
invalid 3-4
typing in 2-7
validating 5-10
dBASE file format 12-1
DBF format 12-1, 12-8
DBMS 15-1
DDE (Dynamic Data Exchange)
See also OLE objects
scripts 10-9
Decimal numbers 6-22
Decimal tabs 7-13
Default
formats 6-22
passwords A-5
Default password 9-3
Defining
See also  Placing
See also Adding
calculation fields 5-5
fields 5-3
global fields 5-8
lookups 8-6
passwords 9-1
portals 6-19
related records 2-5
relational databases 8-9
relationships 8-10
scripts 10-4
summary fields 5-6
value lists 7-3
Deleting
characters 2-14
data 2-7, 5-12
dictionary terms 2-14
fields 5-12, 9-5
from a layout 6-17
find requests 3-5
graphics 2-13
groups 9-5
imported records 12-5
layout parts 6-30
layouts 6-8
master records 2-5, 8-11
movies 2-13
objects 6-13
passwords 9-3
portals 6-20
records 3-8
related records 2-5, 8-11
Script menu items 10-10
script steps 10-5
scripts 10-10
sounds 2-13
text 2-14
value lists 7-5
Design functions 11-12
Designing databases
creating layouts 6-1
planning 5-1
relational 8-7
Destination file, import 12-2
Detail databases. See Related files
Detail tables. See Related files
Dialing phone numbers
procedures A-3
script steps 10-9










