1. Introduction to FileMaker Pro

   1. Chapter 1 Your First Database

      1. A Very Quick Database Tour
      2. Creating a New Database
      3. Opening and Closing Database Files
      4. Saving Your Databases
      5. Adding Records to Your Database
      6. Navigating Your Database
      7. Same Database, Multiple Windows

   2. Chapter 2 Organizing and Editing Records

      1. Views
      2. Advanced Find Mode
      3. Changing Multiple Records
      4. Sorting Records
      5. Editing What's in Your Fields
      6. Paragraph Formatting
      7. Beyond Text: Container Fields
      8. Checking Spelling
      9. Printing and Preview Mode

   3. Chapter 3 Building a New Database

      1. Tables and Fields
      2. Defining Fields
      3. Advanced Field Options
      4. Bringing It All Together

2. Layout Basics

   1. Chapter 4 Layout Basics

      1. What Is a Layout?
      2. Switching Between Layouts
      3. What Makes a Layout
      4. Layout Mode

   2. Chapter 5 Creating Layouts

      1. The Lowdown on Layouts
      2. Creating a Layout from Scratch
      3. Creating Layouts for Reports

   3. Chapter 6 Advanced Layouts and Reports

      1. Value Lists
      2. Advanced Field Controls
      3. Field Behavior
      4. Conditional Formatting
      5. Print-related Layout Options
      6. Format the Number/Date/Time/Graphic
      7. Adding Buttons
      8. Tab Order
      9. Web Viewer Controls
      10. Tab Controls
      11. Reports and Summary Fields

3. Multiple Tables and Relationships

   1. Chapter 7 Multiple Tables and Relationships

      1. Relational Databases Explained
      2. Modeling Your Database
      3. Creating a Relational Database
      4. Relational Databases

   2. Chapter 8 Advanced Relationship Techniques

      1. Creating Related Records
      2. Table Occurrences
      3. Managing Data with Data Tunneling
      4. Building a Data Tunneling Interface
      5. Connecting Databases
      6. Lookups
      7. Advanced Relationships

4. Introduction to Calculations

   1. Chapter 9 Introduction to Calculations

      1. Understanding Calculations
      2. The Structure of a Calculation
      3. Creating a Calculation Field
      4. Auto-Enter Calculations
      5. Validate Data Entry with a Calculation
      6. Replacing Data Using a Calculation
      7. Comments

   2. Chapter 10 Calculations and Data Types

      1. Number Crunching Calculations
      2. Going Beyond Basic Calculations
      3. Text Parsing Calculations
      4. Date and Time Calculations
      5. Aggregate Calculations
      6. Containers in Calculations

   3. Chapter 11 Advanced Calculations

      1. Conditional Formatting
      2. Using the Self Function
      3. Stored, Unstored, and Global Fields
      4. Logical Functions
      5. The Let Function and Variables

   4. Chapter 12 Extending Calculations

      1. Custom Functions
      2. Plug-ins

5. Scripting

   1. Chapter 13 Scripting Basics

      1. Your First Script
      2. The Importance of the Layout
      3. Running Scripts
      4. Understanding ScriptMaker's Windows
      5. Organizing Your Scripts
      6. Branching and Looping in Scripts

   2. Chapter 14 Script Steps

      1. Go to Layout
      2. Scripting for Fields
      3. Working with Records
      4. Finding Records
      5. Sorting Records
      6. Working with Windows
      7. Working with Files
      8. Printing
      9. Other Script Steps

   3. Chapter 15 Advanced Scripting

      1. Commenting Scripts
      2. Asking and Telling the User
      3. Organizing Complex Scripts
      4. Handling Errors
      5. Putting a Complex Script Together

6. Security and Integration

   1. Chapter 16 Security

      1. How Security Works
      2. Privilege Sets
      3. Managing Accounts
      4. Extended Privileges
      5. Scripts and Security

   2. Chapter 17 Sharing Data with Other Systems

      1. Sharing Your Data with Others
      2. External SQL Sources
      3. Exporting Data
      4. Importing Data
      5. Import Data Sources
      6. Importing and Exporting in a Script

   3. Chapter 18 Sharing Your Database

      1. FileMaker Network Sharing
      2. Sharing over the Internet
      3. FileMaker Server
      4. Server Hardware

   4. Chapter 19 Developer Utilities

      1. Copying and Pasting Database Structure
      2. Script Debugger
      3. The Data Viewer
      4. Disable Script Steps
      5. The Database Design Report
      6. Tooltips
      7. Custom Menus
      8. Developer Utilities
      9. File Maintenance

7. Appendixes

   1. Appendix A Getting Help

      1. Getting Help from FileMaker Itself
      2. Getting Help from FileMaker, Inc.
      3. Getting Help from the Community

   2. Appendix B Filemaker Error Codes

1. Colophon

Philip Dangler and Adam Witwer provided quality control for FileMaker Pro 9: The Missing Manual. Ron Strauss wrote the index. The cover of this book is based on a series design originally created by David Freedman and modified by Mike Kohnke, Karen Montgomery, and Fitch (www.fitch.com). Back cover design, dog illustration, and color selection by Fitch. David Futato designed the interior layout, based on a series design by Phil Simpson. This book was converted by Abby Fox to FrameMaker 5.5.6. The text font is Adobe Minion; the heading font is Adobe Formata Condensed; and the code font is LucasFont's TheSans Mono Condensed. The illustrations that appear in the book were produced by Robert Romano and Jessamyn Read using Macromedia FreeHand MX and Adobe Photoshop CS.