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
FileMaker Pro Quick Reference (Mac OS) D-3
Miscellaneous actions
Cancel a dialog box Esc
Cancel an operation 2-. (period)
Check/Uncheck Omit checkbox in Find 2-T (Mac OS X) 2-M (Mac OS 9)
Define Fields dialog box Shift-2-D
Find/Replace dialog box Shift-2-F
Delete a record, layout or request 2-E
Delete a record without dialog Option-2-E
Execute script (first 10 scripts) 2-1 — 2-0 (by number)
Show all records 2-J
Help 2-?
Modify the last find 2-R
New Record, layout or request 2-N
Omit Record (Browse) 2-T (Mac OS X) 2-M (Mac OS 9)
Omit Multiple (Browse) Shift-2-T (Mac OS X) Shift-2-M (Mac OS 9)
Play or record sound in a sound field Space bar
Select all 2-A
Sort 2-S
Status area
In Browse mode In Layout mode
In Find mode
forward or backward in your records
Number of the current record (editable)
Number of records in file
Shows whether records are unsorted,
sorted, or semi-sorted
Percent of magnification
Zooms window smaller or larger
Shows or hides the status area
Choose a different layout
Click a page or drag the bookmark to move
Number of the current
layout (editable)
Layout tools
Portal tool
Fill pattern palette
Emboss palette
Current fill properties
Pen pattern palette
Line width palette
Current line properties
Button tool
Field tool
Part tool
Fill color palette
Fill icon
Pen color palette
Pen icon
Number of the current
request (editable)
Number of existing requests
Click to omit the records found by the
current request
Click to choose operators
(like <, >, and =) to paste into
a find request
Click to begin the search