FileMaker Pro 11: The Missing Manual

Table of contents

1. FileMaker Pro 11: The Missing Manual
2. A Note Regarding Supplemental Files
3. The Missing Credits
   1. About the Authors
   2. About the Creative Team
   3. Acknowledgments
   4. The Missing Manual Series
4. Introduction
   1. Why FileMaker Pro?
   2. What’s New in FileMaker Pro 11
   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. one. 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 Data to Your Database
         1. Creating a Record
         2. Entering Data
            1. Moving between fields
            2. Editing a record
            3. Reverting a record
            4. Duplicating a record
         3. Fields for Lots of Text
         4. Deleting Records
         5. Understanding Browse Mode Error Messages
            1. Typing in vain
      4. Navigating Your Database
         1. Navigating Record by Record
         2. Keyboard Shortcuts
      5. Finding Records
         1. Performing a Find
            1. FastMatch
            2. QuickFind
         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
      9. 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. Zero or More Characters, a.k.a. “Wildcard” (*)
            2. Less Than (<), Less Than or Equal (≤), Greater Than (>), and Greater Than or Equal (≥)
            3. Match Whole Word (=), Match Phrase (” “), and Match Entire Field (= =)
            4. Range (…)
            5. Find Duplicate Values (!)
            6. Today’s Date (//) and Invalid Date or Time (?)
            7. Any One Character (@), Any 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. Preview Mode and Printing
6. two. Building Your First Database
   1. 3. Creating a Custom Database
      1. Creating a New Database
      2. Creating and Managing Fields in Table View
         1. Creating Fields
         2. Managing Field Types
         3. Creating Records in Table View
         4. Inserting a File into a Container Field
         5. Exporting Field Contents
         6. Inserting a File Using QuickTime
      3. Understanding Layouts
         1. The Layout Bar
         2. The Layout Status Toolbar and Layout Mode
         3. Layout Objects
      4. Customizing a Layout
         1. Editing Text Objects and Fields
            1. Moving and resizing fields
            2. Using object grids
            3. Viewing sample data
            4. Editing text objects
            5. Deleting objects
            6. Adding text objects
         2. Using the Inspector
         3. Inserting a Picture on a Layout
         4. Adding Lines and Shapes
         5. Formatting Fields
            1. Formatting a Number field
            2. Adding a field control style and a value list
            3. Editing a value list
            4. Adding a drop-down calendar to a field
            5. Controlling field borders
         6. Customizing a Layout’s Body Part
            1. Adding color to a layout part
            2. Adjusting the Body part’s height
      5. Creating a New Layout
         1. The Format Painter
         2. Making Two Layouts Match
            1. T-Squares
      6. Arrange and Align Tools
         1. Aligning and distributing
            1. Aligning and distributing
            2. Resizing
            3. Grouping/Locking
            4. Arranging
            5. Rotating
   2. 4. Adding Power to Your Database
      1. Creating a Simple Calculation
         1. Creating Fields with Manage→Database
         2. Adding New Fields to a Layout
      2. Creating a Related Table
         1. Understanding the Elements of a Relationship
         2. Creating a Key Field with an Auto-Enter Serial Number
            1. Using Replace Field Contents to add serial numbers
         3. Creating a New Table
            1. Viewing the new table’s layout
         4. Creating a Relationship Between Two Table Occurrences
      3. Creating and Using Portals
         1. Adding a Portal to a Layout
         2. Resizing and Moving a Portal
         3. Context
         4. Creating Records Through a Portal
         5. Editing Records Through a Portal
            1. Deleting records through a portal
         6. Performing Finds with Related Data
      4. Using 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
      5. Adding Merge Fields
         1. Using Symbols to Show Important Info
      6. Writing a Basic Script
         1. Creating a Sort Script
         2. Creating a Button
         3. Applying a Script Trigger
      7. Creating a Dynamic Report with the Assistant
      8. Creating a Trailing Group Report
      9. Changing the Default Account
      10. Summing Up
7. three. Thinking Like a Developer
   1. 5. Creating and Managing a Relational Database
      1. Understanding Relational Databases
      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. Primary and foreign keys
            2. Choosing a good primary key field
         5. Join Tables
      3. Creating a Relational Database
         1. Creating Relationships
         2. Sorting a Relationship
         3. Managing the Relationships Graph
            1. Managing table occurrences using the Tables/Relationships tools
            2. Arrange the graph
            3. Selection tools
            4. Color your table occurrences
            5. Adding notes
            6. Printing the graph
      4. Using Relational Database Power
         1. One Table Occurrence, One Found Set
         2. Viewing Related Fields on a Layout
         3. Creating a Value List Based on a Related Field
      5. Lookups
         1. Creating Lookups
         2. Using a Relookup
         3. Navigating Between Related Records
            1. Go to Related Record
            2. Using GTRR to create a found set
      6. Reviewing Relationship Concepts
         1. Bidirectionality
         2. Implicit Relationships in Action
   2. 6. Field Options
      1. Understanding Field Types
         1. Text
         2. Number
         3. Date
         4. Time
         5. Timestamp
         6. Container
         7. Calculation
         8. Summary
      2. Auto-Enter Field Options
         1. Creation Values
            1. Using Creation Name and Account Name
         2. Modification Values
         3. Serial Number
         4. Value from Last Visited Record
         5. Data
         6. Calculated Value
         7. Looked-up Value
      3. Validation Options
         1. Making Validation Stricter
         2. 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
         3. Indexing
            1. Automatic indexing
            2. Controlling indexing manually
            3. Indexing language
            4. Seeing the index
         4. Printing Field Definitions
      5. 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. 7. Layout Tools
      1. Layout Parts
         1. Parts in Form View
         2. Parts in List View
         3. Parts in Preview Mode
         4. Part Setup Dialog Box
         5. When to Use Each Type
         6. Arranging Parts
      2. Layout Types
         1. Standard Form
         2. Table View
         3. List View
         4. Report
         5. Blank Layout
         6. Labels or Vertical Labels
         7. Envelope
         8. Renaming a Layout
         9. Setting Layout View
         10. Found Sets and Layouts
         11. Layout Setup
         12. Manage Layouts
      3. The Inspector’s Data Tab
         1. Field Control
      4. 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
         10. Field Behavior
      5. Data Formatting
         1. Number Formatting
            1. General
            2. As entered
            3. Boolean
            4. Decimal
            5. Currency
            6. Percent
         2. Date Formatting
            1. As entered
            2. Preset Styles
            3. Custom
         3. Time Formatting
            1. As entered
            2. Other Formats
         4. Timestamp Formatting
         5. Graphic Formatting
            1. Format
            2. Alignment
      6. 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
      7. Tab Order
         1. Customizing the Tab Order
         2. Fixing the Tab Order in the People Database
         3. Preserving the Automatic Order
      8. Merge Fields
      9. Merge Variables
      10. Tooltips
      11. Autoresizing
          1. Autoresizing in List Layouts
      12. 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 & Visibility options
   4. 8. 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. Using a Related Field in a Calculation
      4. 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
         8. Changing the Standard Evaluation Behavior
      5. Auto-Enter Calculations
      6. Validate Data Entry with a Calculation
      7. Replacing Data Using a Calculation
      8. Comments
   5. 9. More Calculations and Data Types
      1. Number Crunching Calculations
         1. Number Function Types
         2. 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. Reviewing the Data and New Business Rules
         2. Planning the Calculations
         3. Constructing the Calculation
      3. Text Calculations
         1. Text Functions
            1. Text function types
            2. Character functions
            3. Word functions
            4. Text editing functions
            5. Text value functions
            6. Text counting functions
         2. 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
   6. 10. Understanding Scripts
      1. Understanding Scripts
      2. Your First Script
         1. Preparing the Database
         2. Planning Your Script
         3. Creating Your Script
         4. Improving Your Script
      3. Shortcuts to the Edit Script Window
      4. The Importance of the Layout
         1. When to Switch
      5. Running Scripts
         1. The Scripts Menu
         2. Buttons
         3. Script Triggers
         4. Performing Scripts When a File Is Opened and Closed
         5. Timer Scripts
      6. Organizing Your Scripts
         1. Creating Script Folders
         2. Creating Menu Separators
      7. 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
      8. Script Triggers
         1. Creating a Simple Script Trigger
         2. Layout Triggers
            1. OnRecordLoad
            2. OnRecordCommit
            3. OnRecordRevert
            4. OnLayoutKeystroke
            5. OnLayoutEnter
            6. OnLayoutExit
            7. OnModeEnter and OnModeExit
            8. OnViewChange
         3. Object Triggers
            1. OnObjectEnter
            2. OnObjectKeystroke
            3. OnObjectModify
            4. OnObjectValidate
            5. OnObjectSave
            6. OnObjectExit
   7. 11. Exploring Script Steps
      1. Go to Layout
      2. Go to Object
         1. Naming objects
            1. Naming objects
            2. Using Go To Object in a Script
      3. 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. Set Field by Name
            4. Insert Calculated Result
            5. Inserting other values
            6. Putting data in container fields
         5. A Field Script in Action
            1. Building the script
         6. Other Steps That Work with Fields
            1. Replace Field Contents and Relookup Field Contents
            2. Set Next Serial Value
            3. Perform Find/Replace
      4. 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
      5. Finding Records
         1. Performing People’s Find Requests
            1. Triggering a Find script
         2. Static Find Requests
         3. Using a Variable to Create Dynamic Find Requests
         4. Constraining and Extending the Found Set
         5. Omitting Records
         6. Modify Last Find
      6. Sorting Records
         1. Sorting Records with an OnRecordLoad Trigger
      7. 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
      8. Working with Files
         1. Opening and Closing Files
         2. Save a Copy As
         3. Other File-Related Script Steps
      9. Printing
      10. Other Script Steps
          1. Open URL
          2. Dial Phone
          3. Set Web Viewer
          4. Execute SQL
          5. Flush Cache to Disk
          6. Exit Application
8. four. Becoming a Power Developer
   1. 12. 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. The Call Stack
         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. Custom Functions
         1. Defining a Custom Function
         2. Editing Custom Functions
         3. Sharing Custom Functions
      7. Custom Menus
         1. Editing a Menu
         2. Creating a New Menu
         3. Using Existing Commands
         4. Submenus
         5. Removing a Menu
         6. 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
      9. File Maintenance
   2. 13. Advanced Relationship Techniques
      1. Advanced Relationships
         1. Self-Join Relationships
            1. No ambiguity or circularity allowed
         2. Multiple Criteria Relationships
            1. Editing a relationship’s criteria
         3. Relationship Operators
      2. Portal Filtering
      3. Understanding Table Occurrences
         1. Adding a new key field to a table
            1. Adding a new key field to a table
            2. Adding a table occurrence
            3. Adding fields for new table occurrences
      4. Table Occurrence Groups
         1. Listing the New Elements You’ll Need
         2. Understanding Table Occurrence Groups
         3. Creating a New Table Occurrence Group
         4. Building the Assign Expenses Layout
            1. Duplicating and editing an existing layout
            2. Copying a portal from another layout
            3. Using GTRR to switch TOGs
      5. Understanding Graph Arrangements
      6. Connecting Database Files
         1. Adding a Table Occurrence from Another File
         2. Defining Data Sources Using a Path
      7. Using Multiple Relationship Techniques
         1. Creating the Invoice Finder Layout
   3. 14. Reporting and Analysis
      1. Summary Fields and Sub-summary Parts
         1. Summary Fields
         2. 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 of
            7. Summarizing repetitions
         3. Advanced Sub-summary Parts
            1. Multiple Sub-summary parts on one layout
         4. Leading and Trailing Grand Summaries
         5. Sub-summary Parts and Printing
      2. 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 messages
      3. Conditional Formatting
         1. Conditional Formatting of Fields
         2. Conditional Formatting of Text Objects
         3. Advanced Conditional Formatting
         4. Removing Conditional Formatting
      4. Basic Charting (Found Set Charts)
         1. Bar
            1. Bar
            2. Horizontal Bar
            3. Line
            4. Area
            5. Pie
      5. Chart Formatting
      6. Charting and Reports
         1. Picking the Right Fields
         2. Choosing an Appropriate Layout Part
         3. Using the Correct Sort Order
      7. Advanced Charting
         1. Delimited Data
         2. Related Records
   4. 15. Advanced Calculations
      1. Understanding Boolean Functions
         1. Using the Self Function
      2. Using Storage Options
         1. Understanding 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
      5. 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
      6. Plug-Ins
         1. Installing Plug-ins
         2. Old and New Plug-ins
         3. Finding Plug-ins
         4. Creating Your Own Plug-ins
   5. 16. Advanced Scripting
      1. Commenting Scripts
      2. Importing Scripts
      3. Communicating with Database Users
         1. Showing a Simple Message
         2. Asking a Simple Question
         3. Asking a More Complex Question
      4. 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
      5. Script Parameters
      6. Script Variables
      7. Handling Errors
         1. The Set Error Capture Script Step
         2. The Get ( LastError ) Function
         3. The Allow User Abort Script Step
      8. Advanced Script Triggers
         1. Install OnTimer Script
         2. Keystroke Triggers
            1. Detecting which keys were pressed
            2. Creating a simple keystroke trigger
            3. Creating a keystroke filter
      9. 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
            3. Adding a script parameter to a Perform Script step
            4. Checking a subscript’s result
            5. Finishing the Create Invoice Record subscript
            6. Finishing the Process Timeslips subscript
            7. The Process Expenses subscript
         5. Testing Scripts
9. five. Integration and Security
   1. 17. 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. Multiple 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
   2. 18. 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
            1. Testing your new account
         2. External Authentication
      4. Extended Privileges
         1. Creating an Extended Privilege
         2. Checking for an Extended Privilege
         3. Assigning Extended Privileges
      5. Managing External File Access
      6. 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
   3. 19. 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. Snapshot Link
      3. External SQL Sources
         1. Setting Up ODBC
            1. The SQL database server
            2. Installing the ODBC driver
            3. Configuring the data source
            4. Finishing ODBC data source configuration
         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
      4. Exporting Data
         1. Grouped Exports
            1. Export formats
      5. Importing Data
         1. Recurring Import
         2. Importing over Existing Data
            1. Update existing records in found set
            2. Update matching records in found set
         3. Creating Tables on Import
         4. Creating a New Database from an Import File
         5. Converting Older FileMaker Files
      6. 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
      7. Importing and Exporting in a Script
         1. Save Records Script Steps
         2. The Import Records Script Step
         3. The Export Records Script Step
10. six. Appendixes
    1. A. Getting Help
       1. Getting Help from FileMaker Pro
       2. FileMaker’s Installed Extras
          1. Starter Solutions
          2. Hands-On Tutorial
          3. XML Examples
       3. The Quick Start Screen
          1. Getting Help from FileMaker, Inc.
          2. The Resource Center
          3. Updaters and Downloads
          4. Web Seminars
          5. FileMaker Training Series
          6. Technical Support
             1. Free support
             2. Paid support
          7. Developer Programs
             1. TechNet
             2. FileMaker Business Alliance
          8. DevCon
       4. Getting Help from the Community
          1. Local User Groups
          2. Mail Lists and Newsgroups
          3. Training/Consultants
    2. B. FileMaker Error Codes
11. Index
12. About the Authors
13. Copyright