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-9
Movies
deleting 2-13
inserting into fields 2-12
script step 10-7
moving 2-12
on the Web 14-4
pasting 2-13
playing 2-12
Moving
fields between files 6-13
movies 2-12
objects
between applications 6-13
between layouts 6-13
on layouts 6-14, 7-19
part labels 6-28
record to record 2-4
to calculation fields 2-7
to summary fields 2-7
Multi-key fields 8-6
Multimedia 2-12
Multiple platforms. See
Cross-platform
Multi-table databases. See
Relational databases
Multiuser files 13-3
hiding in Hosts dialog box
13-4
N
Naming
fields 5-5, 5-11
layouts 6-8
relationships 8-10
scripts 10-4
value lists 7-3
Netscape Navigator 14-11
Networks
changing connections A-2
cross-platform 13-1
FileMaker Server 13-1, 13-5,
13-6
sharing files
Web 14-5
New Layout/Report assistant
described 6-2
No password 9-1
Non-printing objects 7-25
NOT operator 11-4
Number fields
See also Fields
described 5-4
entering data 2-7
finding 3-3
formatting 6-22
sorting numbers 3-9
Number functions 11-6
O
Object Grids
described 7-21
reshaping objects without
6-14
Object Linking and Embedding.
See OLE objects
Objects
adding to layouts 6-27, 7-14,
7-16
aligning 7-18, 7-19
copying 6-13
cutting 6-13
deleting 6-13
described 6-11
editing quickly 1-5
embossed, engraved, drop
shadow effects 7-15
fill 7-14
graphic 7-14, 7-16
grouping 7-17
locking 6-15
moving
between applications 6-13
between layouts 6-13
on layouts 6-14, 7-19
non-printing 7-25
pasting 6-13
positioning 6-14, 7-19
resizing 6-14, 7-19
rotating 7-18
selecting 6-12
sliding
described 7-22
displaying 7-23, 7-24
setting 7-24
stacking order 7-18
text
adding 7-10
deleting 2-14
pasting 2-14
removing 2-14
replacing 2-14
ungrouping 7-17
ODBC
See also Data Access
Companion
configuring control panel
15-3, 15-5
described 15-1
field name considerations 5-3
FileMaker Pro as client
application 15-5–15-13
FileMaker Pro as data source
15-2–15-3
protecting data 15-3
OLE objects
adding to layouts 7-16
working with 2-15, 13-3
Omitting
fields
during printing 7-22, 7-25
from tab order 7-9
records
find requests 3-6
related 3-4
One-to-many relationships,
defined 8-4
One-to-one relationships, defined
8-4
Opening
FileMaker Pro Help xi
files 1-6, 13-3
URLs 10-9
Operators
AND 11-4
comparison 11-3
in find requests 3-2, 3-6
in formulas 11-3
logical 11-4
mathematical 11-3
NOT 11-4
OR 11-4
precedence 11-3
text 11-4
XOR 11-4
Options, default. See Preferences
OR operator 11-4
OR searches 3-5
Oracle databases 15-2, 15-5
Other items 2-9
Oval tool 7-14
P
Page breaks
defining 6-29
viewing
in Preview mode 4-3
Page margins 7-21
Page numbers
and page breaks 6-29
inserting on layout 7-11
Page orientation for printing 4-2,
4-4, 4-5
Pages, Web
setting up 14-10
viewing databases in 14-3,
14-10, 14-14