Chapter 1. About Filemaker Pro 7
FileMaker 7: Highlights of New Features
FileMaker Editions and Their Functions
Chapter 2. Organizing Data Efficiently
Developing a Data Structure Strategy
Creating a Data Structure Chart
Chapter 3. Layout Enhancements
Usability, Legibility, and Logical Grouping
Using Graphics as Layout Elements
Formatting Elements as Buttons
Entering Data in a Standard Layout
Cleaning Up a Layout for Printing
Creating and Formatting Value Lists
Validating Formats with Value Lists
Working with Conditional Value Lists
Validating by Number of Characters
Combining Fields Using Calculations
Formatting Labels or Envelopes
Formatting Form-Letter Modules
Styling Text with Calculations
Updating Auto-Entry Serial Numbers
Chapter 5. Creating Data Reports
Sorting Data for Sub-Summary Reports
Chapter 6. Creating Relationships
Relationship Terminology in FileMaker Pro 7
Creating a Match Field in the Current Table
Using a Match Field to Choose a Related Record
Creating Related Data with Portals
Searching for Self- Relationship Data
Creating a Lookup with a Self-Relationship
Using Multi-criteria Relationships
Chapter 7. Creating Simple Scripts
Extending or Constraining Found Sets in a Script
Chapter 8. Working with Conditional Script Steps
Using Get Functions with If Steps
Using Counters to Control Loops
Controlling Scripts with User Input
Customizing Documents with If Steps
Chapter 9. Extending the Interface with Scripts
To create a layout for searching
Deleting Records in a Related File
Creating Interactive Error Messages
Using Script Parameters for Multipurpose Scripts
Chapter 10. Script Troubleshooting
Chapter 11. Filemaker and Other Programs
Using Scripts to Send Bulk Email
Exporting Data to Stati203 Tables
Using AppleScript with FileMaker Scripting
Copying the Contents of Records
Importing Data from Text Sources
Batch-Importing from a Digital Camera (Mac OS X Only)
Setting the Next Auto-Entry Serial Number
Setting Up or Upgrading FileMaker Mobile
Synchronizing from Mobile to Pro
Exporting from FileMaker with XML
Importing into FileMaker with XML
Chapter 13. ODBC/JDBC Import and Export
About FileMakers ODBC/JDBC Functions
Sharing FileMaker Data Using ODBC in Windows
Using Windows to Access ODBC Data
Using a Mac to Access ODBC Data
Storing SQL Commands in Scripts
Chapter 14. Data Importing and Repairing
Cleaning Up Text Data Before Importing
Importing Data Without Duplications
Replacing Inconsistent Formatting
Chapter 15. Migrating To Version 7
Cleaning Up a Database Before Conversion
Consolidating Multiple Related Files
Security Settings for Converted Files
Chapter 16. Multiuser Files On A Network
Restricting Access with Privilege Sets
Setting Access Privileges by Password
Accessing Databases over the Internet
Chapter 17. Instant Web Publishing
Converting Pre-v.7 Web Databases
Configuring Databases for Web Access
Accessing a Database with a Browser
Adapting Scripts for Web Users
Suppressing the Built-In IWP Interface
Creating a Web-Based Find Script
Appendix A. Filemaker and Third-Party Software