O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

FileMaker Pro 10: The Missing Manual

FileMaker Pro 10: The Missing Manual

10 reviews
by Geoff Coffey, Susan Prosser
Publisher: O'Reilly Media, Inc.
Release Date: January 2009
ISBN: 9780596800604
View table of contents
Start reading

Book Description

The FileMaker Pro 10 desktop database lets you do almost anything with the information you give it -- especially with this book as your guide. Clear, thorough, and accessible, FileMaker Pro 10: The Missing Manual helps you get in, build your database, and get the results you need, whether you're running a business, pursuing a hobby, or planning your retirement. It's the ideal guide for non-technical and experienced folks alike.

Each chapter in this fully updated edition covers the latest timesaving features of FileMaker Pro 10, including saved finds and a redesigned toolbar that reveals information and features more clearly than ever. You'll learn how to import information from the new Bento consumer database (Mac only), write scripts to make your database even easier to use, and send email without leaving FileMaker.

With this book, you will:

  • Get your first database running in minutes and perform basic tasks right away
  • Catalog people, processes, and things with streamlined data entry and sorting tools
  • Use your data to generate reports, correspondence, and other documents with ease
  • Create, connect, and manage multiple tables and set up complex relationships that display just the data you need
  • Crunch numbers, search text, or pin down dates and times with dozens of built-in formulas
  • Outfit your database for the Web, and import and export data to other formats

You'll also get objective advice on which features are really useful, and which aren't. To make the most of this database, you need FileMaker Pro 10: The Missing Manual -- the book that should have been in the box.

Table of Contents

  1. FileMaker Pro 10: The Missing Manual
  2. A Note Regarding Supplemental Files
  3. The Missing Credits
    1. About the Authors
    2. About the Creative Team
    3. The Missing Manual Series
  4. Introduction
    1. Why FileMaker Pro?
    2. What’s New in FileMaker Pro 10
    3. The Very Basics
    4. About This Book
      1. About the Outline
      2. Living Examples
      3. Macintosh and Windows
      4. About → These → Arrows
      5. About MissingManuals.com
      6. Safari® Books Online
  5. I. Getting Started with FileMaker
    1. 1. Working with a Database
      1. A Very Quick Database Tour
        1. Content Area
        2. Scroll Bars
        3. Zoom Controls
        4. Understanding Modes
          1. Status toolbar
      2. Opening and Closing Database Files
        1. Opening a Database
        2. Closing a Database
      3. Adding Records to Your Database
        1. Creating a Record
        2. Entering Data
          1. Moving between fields
        3. Fields for Lots of Text
          1. Reverting a record
          2. Editing a record
          3. Duplicating a record
        4. Deleting Records
        5. Understanding Browse Mode Error Messages
          1. No records present
          2. Typing in a record
      4. Navigating Your Database
        1. Navigating Record by Record
        2. Keyboard Shortcuts
      5. Finding Records
        1. Performing a find
          1. Performing a find
          2. FastMatch
        2. Understanding Find Mode Error Messages
          1. No records match
          2. No valid criteria
          3. Accidental data entry in Find mode
      6. Sorting Records
        1. Understanding Sorting
        2. Beyond the Simple Sort
        3. Multiple Sort Fields
      7. Same Database, Different Views
        1. Viewing a List
        2. Viewing a Table
        3. Creating a New Window
        4. Hiding Windows
          1. Closing hidden windows
        5. Automatically Arranging Windows
      8. Saving Your Database
        1. Saving a Copy of Your Database
        2. Saving a Clone of Your Database
        3. Using FileMaker’s Help Menu
    2. 2. Organizing and Editing Records
      1. Views
        1. Form View
        2. List View
        3. Table View
          1. Modifying Table view
      2. Advanced Find Techniques
        1. Modify Last Find
        2. Multiple Requests
          1. Searching with AND conditions
          2. Searching with OR conditions
        3. Finding by Omitting
          1. Refining a found set with Omit commands
        4. Constraining and Extending the Found Set
          1. Constraining the found set
          2. Extending the found set
        5. Refining Searches with Find Operators
          1. The wildcard (*)
          2. Less Than (<), Less Than or Equal To (≤), Greater Than (>), and Greater Than or Equal To (≥)
          3. Exact Match (=), Literal Text (” “), and Field Content Match (= =)
          4. Range (…)
          5. Duplicates (!)
          6. Today’s Date (//) and Invalid Date or Time (?)
          7. One Character (@), One Digit (#), and Zero or More Characters (*)
          8. Relaxed Search (~)
        6. Using the Find Pop-up Menu
          1. Saving finds
          2. Editing saved finds
      3. Editing What’s in Your Fields
        1. Drag-and-drop Editing
        2. Using the Replace Command
        3. Find and Replace
      4. Changing Text Appearance
        1. Text Formatting
        2. Paragraph Formatting
        3. The Text Ruler
        4. Formatting Tabs
          1. Setting tabs in the Text Ruler
          2. Setting tabs in the Tabs dialog box
      5. Checking Spelling
        1. Spell Checking with Menu Commands
        2. Spell Checking as You Type
        3. Managing Spelling Dictionaries
          1. User dictionaries
      6. Printing and Preview Mode
      7. Beyond Text: Container Fields
        1. Pictures
          1. Copy and paste
          2. Insert → Picture
        2. QuickTime
        3. Sound
          1. Recording sound
        4. File
          1. Exporting data from container fields
    3. 3. Building a New Database
      1. Tables and Fields
        1. Tables: The Foundation of Your Database
        2. Figuring Out What Fields You Need
      2. Defining Fields
        1. Changing a Field’s Name
        2. Duplicating a Field
        3. Deleting a Field
        4. Reordering the Field List
        5. Printing Field Definitions
        6. Field Types
          1. Text
          2. Number
          3. Date
          4. Time
          5. Timestamp
          6. Container
          7. Calculation and summary
      3. Advanced Field Options
        1. Auto-Enter Options
          1. Creation values
          2. Modification values
          3. Serial number
          4. Value from last visited record
          5. Calculated value
          6. Looked-up value
        2. Validation Options
          1. Making validation stricter
        3. Validation Requirements
          1. Strict data type
          2. Not empty
          3. Unique
          4. Existing value
          5. Member of value list
          6. In range
          7. Maximum number of characters
        4. Storage Options
          1. Global storage
          2. Repeating fields
        5. Indexing
          1. Automatic indexing
          2. Controlling indexing manually
          3. Indexing language
          4. Seeing the index
  6. II. Layouts
    1. 4. Understanding Layouts
      1. What Is a Layout?
        1. Types of Layouts
        2. Making a New Layout
        3. Views
      2. The Layout Bar
        1. Renaming a Layout
        2. Found Sets and Layouts
      3. What Makes a Layout
        1. Part Types
          1. Parts in Form view
          2. Parts in List view
          3. Parts in Preview mode
          4. When to use them
        2. Layout Objects
          1. Text objects
          2. Lines and shapes
          3. Images
          4. Fields
      4. Customizing a Layout
        1. The Look
        2. Layout Mode
        3. The Status Toolbar
        4. Arranging Parts
        5. Laying Out Fields and Labels
          1. Moving objects
          2. Resizing objects
          3. Working with text
          4. Removing objects from a layout
          5. Working with fields
        6. Autoresize
        7. Decorating a Layout
          1. Coloring a part
          2. Applying color to text
          3. Adding lines and shapes
          4. Adding pictures
      5. Determining Tab Order
        1. Customizing the Tab Order
        2. Fixing the Tab Order in the People Database
        3. Preserving the Automatic Order
    2. 5. Building Basic Layouts
      1. The Lowdown on Layout Types
        1. Standard Form
        2. Columnar List/Report
        3. Table View
        4. Labels or Vertical Labels
        5. Envelope
        6. Blank Layout
      2. Creating a Layout from Scratch
        1. Adding a New Layout
        2. Matching Two Layouts
          1. Matching part sizes with the Object Info palette
          2. Matching part sizes with the T-squares
          3. Finishing the header
        3. Set Up the Body
          1. Making data flow with merge fields
          2. Matching styles
          3. Adding fields to a layout
          4. Using symbols to show important info
          5. Rotating objects
          6. Decorate the layout
        4. Setting Layout View
        5. Setting Anchors in List Layouts
      3. Conditional Formatting
        1. Conditional Formatting of Fields
        2. Conditional Formatting of Text Objects
        3. Advanced Conditional Formatting
        4. Removing Conditional Formatting
      4. Web Viewer Objects
        1. Putting a Web Viewer on a Layout
        2. Web Viewer Options
          1. Allow interaction with web viewer content
          2. Display content in Find mode
          3. Display progress bar
          4. Display status message
      5. Adding Tab Controls
        1. Creating a Tab Control
        2. Editing Tab Controls
          1. Adding, removing, and reordering tabs
          2. Default front tab
          3. Tab justification
          4. Appearance
          5. Tab Width
          6. Formatting a tab control
        3. Deleting a Tab Control
      6. Creating Layouts for Printing
        1. Visualize the Result in Preview Mode
        2. Print Margins
        3. Columns
        4. Sliding Layout Objects
          1. When to use sliding
          2. Choosing the objects to slide
          3. Setting sliding options
          4. More Sliding/Printing options
        5. Setting Layout Order
        6. Layout Setup
    3. 6. Advanced Layouts and Reports
      1. Value Lists
        1. Creating Value Lists
          1. Values from a field
        2. Editing Value Lists
      2. Advanced Field Controls
        1. Edit Box
        2. Drop-Down List
        3. Pop-Up Menu
        4. Checkbox Set
        5. Radio Button Set
        6. Drop-Down Calendar
        7. Auto-Complete
          1. Auto-Complete in Edit Boxes
          2. Auto-Complete in drop-down lists
        8. Repetitions
        9. Display Data From
      3. Format the Number/Date/Time/Graphic
        1. Number Formatting
          1. General format
          2. Leave data formatted as entered
          3. Format as Boolean
          4. Format as decimal
        2. Date Formatting
          1. Leave data formatted as entered
          2. Format as
          3. Custom
        3. Time Formatting
          1. Leave data formatted as entered
          2. Format as
        4. Timestamp Formatting
        5. Graphic Formatting
          1. Scale
          2. Alignment
      4. Adding Buttons
        1. Creating Buttons with the Button Tool
        2. Turning an Existing Layout Object into a Button
        3. Making a Button Not a Button
        4. Button Actions
          1. Go to Layout
          2. Go to Record/Request/Page
          3. Go to Field
          4. Go to Next Field and Go to Previous Field
          5. Enter Browse Mode, Enter Find Mode, and Enter Preview Mode
          6. Editing actions
          7. Field actions
          8. Record actions
          9. Found set actions
          10. Window actions
          11. Print actions
          12. Open Menu Item actions
          13. Exiting FileMaker
      5. Summary Fields and Sub-Summary Parts
        1. Summary Fields
        2. Using Sub-Summary Parts
          1. Multiple sub-summary parts on one layout
        3. Leading and Trailing Grand Summaries
        4. Sub-Summary Parts and Printing
        5. Other Summary Field Types
          1. Total of
          2. Average of
          3. Count of
          4. Minimum and Maximum
          5. Standard Deviation of
          6. Fraction of Total
          7. Summarizing repetitions
  7. III. Multiple Tables and Relationships
    1. 7. Adding Multiple Tables and Relationships
      1. Relational Databases Explained
      2. Modeling Your Database
        1. Choosing Entities
        2. Finding Relationships
          1. One-to-many relationships
          2. One-to-one relationships
          3. Many-to-many relationships
        3. The Entity-Relationship Diagram
          1. Creating an ER diagram
        4. Keys
          1. Choosing a good key field
          2. Primary and foreign keys
        5. Join Tables
      3. Creating a Relational Database
        1. Creating the Tables
        2. Creating the Fields
          1. Adding primary keys
          2. Adding foreign keys
        3. Defining the Relationships
        4. Cleaning Up the Relationship Graph
          1. Selection tools
          2. Arrange the graph
          3. Color your table occurrences
          4. Adding notes
          5. Printing the graph
          6. Deleting relationships
        5. Finishing the Field Definitions
          1. Customers table fields
          2. Jobs table fields
          3. Expenses table fields
          4. Timeslips table fields
          5. Invoices table fields
          6. Line Items table fields
          7. Payments table fields
      4. Relational Databases
        1. One Table Occurrence, One Found Set
        2. Viewing Related Fields
        3. Adding or Editing Data with Relationships
        4. Editing Related Data
          1. Portals
          2. Editing data through a portal
    2. 8. Advanced Relationship Techniques
      1. Creating Related Records
        1. Value Lists Based on Fields
        2. Creating Related Records Through a Portal
          1. Preparing the relationship
          2. Adding a portal to a layout
          3. Adding records in a portal
        3. Navigating Between Related Records
          1. Go to Related Record
          2. GTRR with a found set
      2. Table Occurrences
        1. Understanding Table Occurrences
        2. Relationships with Table Occurrences
          1. Adding a new key field to a table
          2. Adding a table occurrence
          3. Adding fields for new table occurrences
      3. Managing Data with Data Tunneling
        1. Understanding Data Tunneling
          1. What you need in your data tunneling interface
        2. Understanding Table Occurrence Groups
        3. Managing the Relationships Graph
      4. Building a Data Tunneling Interface
        1. Creating a Global Field
        2. Creating a New Table Occurrence Group
        3. Building a Global Field Layout
          1. Using a global pop-up field to change the display in a value list
      5. Connecting Database Files
        1. Adding a Table Occurrence from Another File
        2. Defining Data Sources Using a Path
      6. Lookups
        1. Creating Lookups
        2. Using a Relookup
      7. Advanced Relationships
        1. Relationships with More than One Criterion
        2. Other Relationship Operators
        3. Creating the Invoice Finder
  8. IV. Calculations
    1. 9. Understanding Calculations
      1. Understanding Calculations
        1. Creating a Calculation
      2. The Structure of a Calculation
        1. Using Fields in Calculations
        2. Using Constants in Calculations
          1. Number constants
          2. Text constants
        3. Using Operators in Calculations
          1. Mathematical operators
          2. The concatenation operator
          3. Comparison operators
          4. Logical operators
          5. The ^ operator
          6. Parentheses
        4. Functions
          1. Text functions
          2. Text formatting functions
          3. Number functions
          4. Date functions
          5. Time functions
          6. Timestamp functions
          7. Aggregate functions
          8. Summary functions
          9. Repeating functions
          10. Financial functions
          11. Trigonometric functions
          12. Logical functions
          13. Get functions
          14. Design functions
          15. Custom functions
          16. External functions
        5. Expressions
      3. Creating a Calculation Field
        1. Understanding the Specify Calculation Dialog Box
          1. Table occurrence context
          2. Field list
          3. Operators
          4. Function list
          5. Result type
          6. Calculation box
          7. Repetitions
      4. Auto-Enter Calculations
      5. Validate Data Entry with a Calculation
      6. Replacing Data Using a Calculation
      7. Comments
    2. 10. More Calculations and Data Types
      1. Number Crunching Calculations
        1. Number Operators
        2. Number Function Types
        3. Using Number Functions
          1. Abs( )
          2. Average( )
          3. Count( )
          4. Floor( ) and Ceiling( )
          5. List( )
          6. Round( )
          7. SetPrecision( )
      2. Going Beyond Basic Calculations
        1. Preparing the Data
        2. Building the Calculation Fields
        3. Constructing the Calculation
      3. Text Calculations
        1. The Concatenation Operator
        2. Text Functions
          1. Text function types
          2. Character functions
          3. Word functions
          4. Text editing functions
          5. Text value functions
          6. Text counting functions
        3. Text Formatting Functions
          1. TextColor( ) and RGB( )
          2. TextFont( )
          3. TextSize( )
          4. TextStyleAdd( ) and TextStyleRemove( )
      4. Date and Time Calculations
        1. Math with Dates and Times
          1. Dates
          2. Times
        2. Parsing Dates and Times
        3. Calculations that Create Dates and Times
          1. The secret powers of Date()
      5. Containers in Calculations
        1. Calculations with Pictures, Sounds, Movies, and Files
        2. Calculations with References
    3. 11. Advanced Calculations
      1. Conditional Formatting Formulas
        1. Understanding Boolean Functions
        2. Using the Self( ) Function
      2. Using Storage Options
        1. Stored and Unstored Calculation Fields
          1. Field dependencies
          2. Deciding when to store
          3. Indexing calculations
        2. Global Calculation Fields
      3. Logical Functions
        1. Conditional Functions
          1. The If( ) function
          2. The Case( ) function
          3. The Choose( ) function
        2. Constructing a Conditional Calculation
          1. Total Due calculation #1: Using the If( ) function
          2. Total Due calculation #2: Using the Case( ) function
      4. The Let( ) Function and Variables
        1. Defining Calculation Variables
          1. Total Due calculation #3: Using the Let( ) function
        2. The Life of a Variable
          1. Local variables
          2. Global variables
        3. Nesting Let( ) Functions
    4. 12. Extending Calculations
      1. Custom Functions
        1. Defining a Custom Function
        2. Editing Custom Functions
        3. Recursion
          1. Step 1: Solve the first case
          2. Step 2: Assume your function already works, and use it
          3. Step 3: Find a stopping point
      2. Plug-Ins
        1. Installing Plug-ins
        2. Old and New Plug-ins
        3. Finding Plug-ins
        4. Creating Your Own Plug-ins
  9. V. Scripting
    1. 13. Understanding Scripts
      1. Your First Script
        1. Preparing the Database
        2. Planning Your Script
        3. Creating Your Script
        4. Improving Your Script
      2. The Importance of the Layout
        1. When to Switch
      3. Running Scripts
        1. The Scripts Menu
        2. Buttons
        3. Script Triggers
        4. Opening and Closing Scripts
        5. Timer Scripts
      4. Organizing Your Scripts
        1. Creating Script Folders
        2. Creating Menu Separators
      5. Branching and Looping in Scripts
        1. Branching with If, Else If, Else, and End If
        2. Testing Multiple Conditions
        3. Looping
          1. Using Go to Record/Request/Page to exit a loop
      6. Script Triggers
        1. Layout Triggers
          1. OnRecordLoad
          2. OnRecordCommit
          3. OnRecordRevert
          4. OnLayoutKeystroke
          5. OnLayoutLoad
          6. OnModeEnter and OnModeExit
        2. Object Triggers
          1. OnObjectEnter
          2. OnObjectKeystroke
          3. OnObjectModify
          4. OnObjectSave
          5. OnObjectExit
        3. A Simple Script Trigger
    2. 14. Exploring Script Steps
      1. Go to Layout
      2. Scripting for Fields
        1. Navigating Fields
          1. Go to Field
          2. Go to Next Field and Go to Previous Field
        2. Editing Commands
        3. Selecting Text
        4. Editing Field Data
          1. Avoiding Cut, Copy, and Paste
          2. Set Field
          3. Insert Calculated Result
          4. Inserting other values
          5. Putting data in container fields
          6. Set Field by Name
        5. A Field Script in Action
          1. Building the script
        6. Other Steps That Work with Fields
          1. Perform Find/Replace
          2. Replace Field Contents and Relookup Field Contents
          3. Set Next Serial Value
      3. Working with Records
        1. Creating, Duplicating, and Deleting Records
        2. Navigating Among Records
          1. Go to Record/Request/Page
          2. Go to Related Record
        3. Opening, Reverting, and Committing Records
          1. Open Record/Request
          2. Commit Record/Request
          3. Revert Record/Request
        4. Copying Records
          1. Copy Record/Request
          2. Copy All Records/Requests
        5. Working with Portals
          1. Go to Portal Row
      4. Finding Records
        1. Performing People’s Find Requests
          1. Triggering a Find script
        2. Static Find Requests
        3. Dynamic Find Requests
        4. Constraining and Extending the Found Set
        5. Omitting Records
        6. Modify Last Find
      5. Sorting Records
        1. Sorting Records Automatically
      6. Working with Windows
        1. Creating Windows
        2. Bringing a Window to the Front
        3. Closing a Window
        4. Moving and Resizing Existing Windows
          1. Adjust Window
          2. Arrange All Windows
          3. Move/Resize Window
        5. Other Window-Related Script Steps
      7. Working with Files
        1. Opening and Closing Files
        2. Save a Copy As
        3. Other File-Related Script Steps
      8. Printing
      9. Other Script Steps
        1. Open URL
        2. Dial Phone
        3. Set Web Viewer
        4. Execute SQL
        5. Flush Cache to Disk
        6. Exit Application
    3. 15. Advanced Scripting
      1. Commenting Scripts
      2. Communicating with Database Users
        1. Showing a Simple Message
        2. Asking a Simple Question
        3. Asking a More Complex Question
      3. Organizing Complex Scripts
        1. The Perform Script Script Step
        2. Halt Script and Exit Script
          1. Exit Script (Result)
          2. Organizing scripts that use Halt or Exit Script
        3. Script Parameters
        4. Script Variables
      4. Handling Errors
        1. The Set Error Capture Script Step
        2. The Get ( LastError ) Function
        3. The Allow User Abort Script Step
      5. Putting a Complex Script Together
        1. Planning the Script
        2. Considering Exceptions
        3. Creating Subscripts
          1. Creating subscript placeholders
          2. Creating skeleton subscripts
        4. Finishing the Subscripts
          1. The Find Unbilled Activity subscript
          2. Copying and editing existing script steps
        5. Adding a Script Parameter to a Perform Script Step
          1. The Create Invoice Record subscript
          2. The Process Timeslips subscript
          3. The Process Expenses subscript
          4. Finishing the main script
        6. Testing Scripts
      6. Advanced Script Triggers
        1. Install OnTimer Script
        2. Keystroke Triggers
          1. Detecting which keys were pressed
          2. Creating a simple keystroke trigger
          3. Setting up a keystroke filter
  10. VI. Security and Integration
    1. 16. Adding Security
      1. How Security Works
        1. Who Gets Access
        2. What They Can Do
      2. Privilege Sets
        1. Understanding Privilege Sets
          1. The built-in privilege sets
          2. Custom privilege sets
        2. Understanding Individual Privileges
          1. Other privileges
          2. Creating a privilege set
          3. Data Access and Design Privileges
          4. Creating record-level access
          5. Editing a privilege set
      3. Managing Accounts
        1. Adding a New Account
        2. External Authentication
      4. Extended Privileges
        1. Creating an Extended Privilege
        2. Checking for an Extended Privilege
        3. Assigning Extended Privileges
      5. Scripts and Security
        1. Detecting Privileges in a Script
        2. Handling Security Errors
        3. Running Scripts with Full Access Privileges
        4. Managing Security with Scripts
          1. Add Account
          2. Delete Account
          3. Reset Account Password
          4. Change Password
          5. Enable Account
          6. Re-Login
    2. 17. Sharing Data with Other Systems
      1. Sharing Your Data with Others
        1. Save/Send Records As
          1. Saving as Microsoft Excel
          2. Saving as Portable Document Format (PDF)
      2. External SQL Sources
        1. Setting Up ODBC
          1. The SQL database server
          2. Installing the ODBC driver
          3. Configuring the data source
        2. Connecting FileMaker to a SQL Data Source
        3. Adding SQL Tables to a FileMaker Database
          1. Creating relationships
          2. Shadow tables
        4. Using SQL Tables
      3. Exporting Data
        1. Grouped Exports
          1. Export formats
      4. Importing Data
        1. Importing Over Existing Data
          1. Update existing records in found set
          2. Update matching records in found set
        2. Creating Tables on Import
        3. Creating a New Database from an Import File
        4. Converting Older FileMaker Files
      5. Import Data Sources
        1. File
        2. Folder
          1. Importing a folder of pictures or movies
          2. Importing a folder of text files
        3. Digital Camera
        4. XML Data Source
          1. XML export
        5. Bento Data Source
        6. ODBC Data Sources
      6. Importing and Exporting in a Script
        1. Save Records Script Steps
        2. The Import Records Script Step
        3. The Export Records Script Step
    3. 18. Sharing Your Database
      1. FileMaker Network Sharing
        1. Setting Up a Host Computer
        2. Opening a Shared File
        3. The Open Remote File Dialog Box
          1. Choosing a host computer
          2. Choosing a file
      2. Sharing over the Internet
        1. Turning on Web Sharing
          1. Advanced Web Publishing Options
          2. Configuring file access
        2. Connecting from a Web Browser
        3. Custom Home Page
      3. FileMaker Server
        1. File Compatibility
        2. Installing FileMaker Server
          1. Single Machine installation
          2. Two Machine installation
          3. Configuring your server
        3. Administering FileMaker Server
          1. Installing a Database
          2. Scheduling a backup
        4. Testing Your Server
      4. Server Hardware
    4. 19. Applying Developer Utilities
      1. Copying and Pasting Database Structure
        1. Importing Tables and Fields
        2. Copying and Pasting Tables
        3. Copying and Pasting Fields
        4. Copying Scripts and Script Steps
      2. Script Debugger
        1. Controlling Script Execution
        2. Breakpoints
        3. Examining Errors
        4. Pause on Error
        5. Active Scripts
        6. Working with the Debugger Window
      3. The Data Viewer
        1. The Current Tab
        2. The Watch Tab
      4. Disable Script Steps
      5. The Database Design Report
        1. Generating the DDR
        2. Using the DDR
        3. Finding Broken Elements with the DDR
      6. Tooltips
      7. Custom Menus
        1. Editing a Menu
        2. Creating a New Menu
        3. Removing a Menu
        4. Installing Custom Menu Sets
      8. Developer Utilities
        1. Using the Developer Utilities
          1. Renaming files
          2. Create Runtime Solution application(s)
          3. Remove admin access from files permanently
          4. Enable Kiosk mode for non-admin accounts
          5. Databases must have a FileMaker file extension
          6. Create error log for any processing errors
          7. Loading and saving settings
        2. Delivering a Runtime Solution
  11. VII. Appendixes
    1. A. Getting Help
      1. Getting Help from FileMaker Itself
        1. The Resource Center
        2. FileMaker Pro Help
        3. Templates
        4. XML Examples
      2. Getting Help from FileMaker, Inc.
        1. Updaters and Downloads
        2. Downloadable Resources
        3. Knowledge Base
        4. Forums
        5. Technical Support
          1. Free support
          2. Paid support
        6. Developer Programs
      3. Getting Help from the Community
        1. Mail Lists and Newsgroups
        2. Training/Consultants
        3. DevCon
    2. B. FileMaker Error Codes
  12. Index
  13. About the Authors
  14. Colophon
  15. Copyright