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
Symbols
! 3-6
– 5-3, 11-3
" 5-3
" " 3-2, 3-3, 11-2, 11-4, 11-12
## 7-11
& 5-3, 11-4
( 5-3
) 5-3
* 3-2, 3-6, 5-3, 11-3
+ 5-3, 11-3
, 5-3
... 3-4
/ 5-3, 11-3
// 3-4, 6-24, 7-11
: 5-3
:: 5-3, 6-24, 7-11
; 5-3
< 3-4, 5-3, 11-3
<= 3-4, 11-3
<> 11-3
= 3-3, 3-6, 5-3, 11-3
== 3-3
> 3-4, 5-3, 11-3
>= 3-4, 11-3
? 3-4, 6-23
@ 3-2
@@ 7-11
^ 11-3
_ 5-3, 13-4
|| 7-11
¶ 11-4
≠ 5-3, 11-3
≤ 3-4, 11-3
≥ 3-4, 11-3
A
Access privileges
associating passwords with
groups 9-3
changing 9-3, 9-5
described 9-1
fields 9-4, 9-6
groups 9-1, 9-3
layouts 9-4, 9-5, 9-6
passwords 9-1, 9-6
record locking 13-2
related files
planning 8-9
working with 8-5, 9-2
selecting 9-1, 9-3
Web 14-5, 14-8
Accessing data from a third file
8-14
Accounts. See Access privileges
Actions. See Scripts
ActiveX Automation 10-1
Adding
See also Defining, Inserting,
Placing
comments to scripts 10-9
fields 5-3
graphics to layouts 7-14
layout parts 6-26
objects to layouts 6-27, 7-14
records 2-4
related records 2-5, 8-11
Script menu items 10-5, 10-10
scroll bars to fields 7-2
text to layouts 7-10
Aggregate functions 11-7
Aligning
objects 7-18, 7-19
tabs 7-13
text 7-12, 7-13
AND operator 11-4
AND searches 3-5
in match fields 8-6
Animation 2-12
Appearance
layout themes 6-5
web styles 14-11
Apple events 10-1, 10-9
AppleScript 10-1, 10-9
Application preferences A-1
Arrange toolbar 1-5
ASCII sort 3-9
Attributes
fill 7-15
paragraph 7-13
pen 7-15
tab 7-13
text 6-22, 7-12
Authorized users. See Access
privileges
Auto Enter 5-8
AutoGrid. See Object Grids 7-21
Automatic phone dialing A-3
Automating tasks. See Scripts
Average for summary fields 5-7
AVI format 2-12
B
Background color 7-14. See also
Themes, layout
Backups B-1
Baselines, field borders 7-2
BASIC format 12-1
Batteries, preferences for saving
A-3
Beeps
in spell checking A-6
script for 10-9
Blank
passwords 9-1, 9-3
records, printing 4-5
Blank layout
See also Layouts
described 6-5
Blank spaces, closing up. See
Sliding objects
Body 6-25
Book icon
Browse mode 2-1, 2-4
Find mode 3-6
Layout mode 6-8
Preview mode 4-4
Boolean expressions 11-3
Boolean values
described 3-3
finding 3-4
formatting 6-22
Borders 7-14
button 7-17
field 7-1
Boundaries of fields, text, buttons
7-17
Break fields 6-26, 6-27
BrioQuery 15-2
Browse mode 1-3, 2-1
Browser, Web
home page 14-3, 14-6
opening URL 2-8, 10-9, 14-3
protecting files 14-5
requirements 14-11
setting up views for 14-10
starting 10-9