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
I-8
FileMaker Pro User’s Guide
duplicating 6-8
Envelope 6-5
field boundaries 7-17
fields
displaying 1-3, 6-1
dragging onto layout 6-16
placing 6-15
removing 6-17
selecting 6-12
form layout 6-3
form view 2-2
graphic objects 7-14, 7-16
importing 6-8
Labels 6-4
margins 7-22
modifying 6-8
naming 6-8
objects
adding 6-12, 7-14, 7-16
deleting 6-13
enhancing 7-15
locking 6-15
non-printing 7-25
on Web 14-12
placing related records 6-16
print area 7-22
printing
overview 7-22
procedures 4-4
subsummary reports 4-3
wide 4-2
related fields
placing 6-16
removing 6-17
removing 6-8
renaming 6-8
reordering the menu list 6-8
setting preferences A-2, A-5
setting up views 6-10
Standard form 6-3
switching 6-8
text, adding 7-10
tools
described 6-11
locking 7-14, A-2
types 6-3
Leading summaries 6-26
Leading. See line spacing, custom
Line spacing, custom 7-13
Lines 7-14
Links, between database files. See
Relationships
List separators 11-5
Lists, pop-up. See Pop-up lists
Lists, viewing records as 2-2
Literal text searches 3-3
Local Data Access Companion
15-2
Locking
objects 6-15
shared records 13-2
tools 7-14
Log, of Web activity 14-8
Logical
AND search 3-5
functions 11-10
operators 11-4
OR search 3-5
Lookups
and accessing related data
from third file 8-14
and relational databases 8-1
changing 8-13
defining 8-6, 8-13
defining relationships 8-10
destination field as match field
8-6
lookup destination field 8-2
lookup source field 8-2
stopping or suspending 8-13
updating 8-13
Lotus 1-2-3 format 12-1
M
MacIPX 13-2
Macros. See Scripts
Mail merge
using merge fields 6-17
using ODBC 15-2
Mailing labels 6-4
Main database. See Master file
Main forms. See Master records
Many-to-many relationships,
defining 8-15
Margins
alternating 7-21
changing, text ruler 7-12
displaying
in Layout mode 7-22
in Preview mode 4-3
labels 7-21
setting 7-21
Master file
described 8-2
planning 8-8
Master password
defining 9-1
groups 9-5
Master records
copying 2-8
deleting 2-5, 8-11
duplicating 2-5
finding with related fields 3-4
sorting with related fields 3-9
Master table. See Master file
Match fields
See also Fields
calculation formulas in 8-5
described 8-2
field types for 8-5
in import update 12-2
indexing 8-5
multiple values in 8-6
non-alphanumeric characters
in 8-6
planning 8-5
Matching records, updating 12-2
Mathematical operators 11-3
Maximizing window size A-5
Maximum for summary fields 5-7
Memory preferences A-2
Menu commands
performing 1-4
Menu commands, access
privileges 9-2
Menus
context, described 1-5
File
listing recent files A-2
Font, customizing 7-13
layout pop-up 6-8
Script
adding items 10-5, 10-10
deleting items 10-10
reordering items 10-11
Menus, pop-up. See Pop-up
menus
Merge fields
described 6-17, 7-24
formatting 6-18
placing 6-17
Messages, sending 13-3
Microsoft Access 15-2
Microsoft Excel. See Excel
Microsoft SQL Server 15-2, 15-5
Microsoft Visual Basic 15-2
Microsoft Word 12-1, 15-2
MIDI format 2-12
Minimum for summary fields 5-7
Mode pop-up menu 1-3, 6-1
Modems, configuring A-3
Modes 1-3
Modifying. See Changing