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-7
I
Identification fields 10-14
Importing
See also Exchanging files,
Exporting, Inserting
appending new records 12-2,
12-3
canceling 12-5
cross-platform considerations
12-1
data order 12-2
described 12-1
destination file 12-2
dictionaries 2-14
Excel spreadsheets 12-4
exception fields 12-2
field order 12-4
field types 12-6
file formats supported 12-1
found set 12-5
into existing files 12-3
layouts 6-8
ODBC data 15-5–15-13
from more than one table
15-8, 15-11
options 12-2
record order 12-2
related records 12-2
repeating fields 12-5
replacing data 12-2, 12-3
requirements 12-7
scripts 10-11
shared files 12-1
source file 12-2
updating existing records
12-2, 12-3, 12-6
validating data 12-6
versus copying and pasting
12-1
Index
in FileMaker Pro Help xii
pasting from 2-7
Indexing
fields 5-11
match fields 8-5
text field limitations 3-3, 3-6,
8-5
Inserting
graphics 2-11
movies 2-12
Instant Web Portal 14-3
Instant Web Publishing
built-in home page 14-3, 14-6,
14-8
described 14-2
disabling or enabling 14-8
language in interface 14-8
setting up pages 14-10
sharing files 14-2, 14-7
showing value lists 7-7
styles 14-11
testing databases 14-13
using Scripts with 10-1
viewing browser pages 14-3,
14-6, 14-14
International files 1-7
Internet
See also Web
access 14-4
described 14-1
Internet Explorer 14-11
Internet Service Provider. See ISP
Intranet 14-1
See also Web
IP addresses 14-2
defined 14-2
limiting 14-2, 14-7, 14-9
specifying port numbers 14-9
typing in browser 14-3
ISP 14-2, 14-5
J
Java Script, in Web browsers
14-11
Join expressions. See
Relationships
Join fields. See Match fields
Join files for many-to-many
relationships 8-15
Join, SQL 15-11
Joins. See Relationships
K
KAR format 2-12
Key fields. See Match fields
Keyboard shortcuts
for Mac OS D-1
for Windows C-1
scripts 10-11
showing A-2
L
Labels
See also Labels layout
field 6-16, 7-10
margins 7-21
printing 4-3, 6-6
sizes 6-4
Labels layout
See also Layouts
customizing 6-7
described 6-4
page setup 6-6
printing 6-6, 6-7
standard sizes 6-4
Language, in sorting 3-8
Launching FileMaker Pro 1-6
Layout mode 1-3, 6-1
Layout objects. See Objects
Layout parts
adding 6-26
adding objects to 6-27
body 6-25
changing 6-26, 6-29, 6-30
deleting 6-30
described 6-25
field labels 6-16
footer 6-25
grand summary 6-26
header 6-25
modifying 6-30
page breaks 6-29
page numbers 6-29
reordering 6-29
resizing 6-30
subsummary 6-26
title footer 6-25
title header 6-25
Layout pop-up menu 2-1, 6-8
Layout text. See Text
Layouts
access privileges 9-1, 9-4, 9-5,
9-6
adding fields 6-15
adding graphics 7-14, 7-16
adding objects 6-12
Blank 6-5
blank space, removing 7-22
buttons 10-12
changing 6-8
choosing 6-8
Columnar list/report 6-3
columns
page breaks 6-29
resizing 7-22
setup 6-9
creating 6-2
custom line spacing 7-13
deleting 6-8
deleting fields from 6-17
described 1-3, 6-1