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-11
Preview mode 1-3, 4-3
Previewing
See also Printing
columns 6-9
layouts 4-3
records 4-3
subsummary reports 6-28
Primary keys. See Match fields
Print area
objects outside 7-22
viewing 4-3, 7-22
Print preview. See Preview mode
Printer, selecting 4-2
Printing
access privileges for 9-1
blank records 4-5, 7-22
envelopes 4-3
field definitions 4-5, 7-22
fixed margins 7-21
forms 4-4, 7-22
labels 4-3
setup 6-6
tips 6-6
layouts 4-4, 7-22
merge fields 6-18
non-printing objects 7-25
page orientation 4-2, 4-4, 4-5
previewing 4-3
print area 4-3, 7-22
procedures 4-4
records 4-4
reports 4-4
reports with grouped data 4-3
script definitions 4-4, 7-22
scripts 4-5
setup 4-2, 4-5
subsummary reports 4-3
wide layouts 4-2
Privileges. See Access privileges
Properties, table 6-10
Protecting files. See Access
privileges
Publishing, databases on the Web
14-1
overview 14-6
Pushbuttons. See Buttons
Q
Query, SQL 15-1
QuickTime
described 2-12
script step 10-7
Quitting FileMaker Pro 1-8
Quotation marks in searches 3-2,
3-3
Quotes, smart A-5
R
Radio buttons
See also Value lists
choosing from 2-9
displaying field values 7-6
editing 2-9
Ranges, finding 3-4
Read/write password. See Access
privileges
Read-only password. See Access
privileges
Record locking 13-2
Record numbers
inserting on layout 7-11
Recording
scripts 10-4
sounds 2-13
Records
access privileges 9-1
adding 2-4
on Web 14-16
appending 12-3
browsing
groups of 2-1
in a list 2-2
individual 2-2
on Web 14-14
sorted records 3-8
copying 2-4, 2-8
current 2-3
deleting 3-8
on Web 14-16
deleting duplicates 3-6
described 1-2
displaying sorted related 8-11
duplicating 2-4
editing, on Web 14-17
exporting 12-6
finding 3-1
example script 10-13
on Web 14-15
importing 12-2
locked 13-2
matching 12-2
moving to 2-4
numbers 7-11
omitting 3-6
printing
blank 4-4
in columns 6-8
large 4-3
procedures 4-4
reserializing 2-10
reverting 2-7
selecting 2-3
semi-sorted 3-9
sorting 3-8
on Web 14-13
related records 8-11
viewing as forms, lists, or
tables 2-2
Records, master. See Master
records
Records, related. See Related
records
Recovering files B-3
Rectangle tool 7-14
Registering FileMaker Pro ix
Related fields
See also Fields; Relational
databases
calculations 5-5
changing 6-17
described 8-2
display on Web 14-6
field definitions 5-12
finding 3-4
on layouts 6-16
planning 8-8
removing from a layout 6-17
sorting on 3-9
summarizing data 8-12
syntax for field names 8-2
Related files
See also Files; Relational
databases
access privileges 8-5, 8-9, 9-2
accessing data from a third file
8-14
changing in relationship 8-10
described 8-2
planning 8-8
Related records
See also Records; Relational
databases
adding 2-5, 8-11
copying 2-8
defining 2-5
deleting 2-5, 8-11
described 8-2
displaying in portals 6-16
duplicating 2-5
exporting 12-7
finding and omitting 3-4