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