VISUAL QUICKPRO GUIDE FileMaker Pro 7 Advanced FOR WINDOWS AND MACINTOSH [Electronic resources] نسخه متنی

Copyright

Acknowledgments

Chapter 1. About Filemaker Pro 7

FileMaker 7: Highlights of New Features

FileMaker Editions and Their Functions

Using This Book

Windows and Macintosh

Chapter 2. Organizing Data Efficiently

About Relational Databases

Gathering Information

Creating a Field List

Developing a Data Structure Strategy

Creating a Data Structure Chart

Field Design Tactics

Implementing Relationships

Testing Your Database

Chapter 3. Layout Enhancements

Usability, Legibility, and Logical Grouping

Cross-Platform Issues

Using Format Painter

Using Graphics as Layout Elements

Formatting Elements as Buttons

Entering Data in a Standard Layout

Moving Through Fields

Cleaning Up a Layout for Printing

Creating and Formatting Value Lists

Validating Formats with Value Lists

Working with Conditional Value Lists

Using Calculated Field Labels

Creating Field Masks

Validating by Number of Characters

Chapter 4. Calculation Fields

Combining Fields Using Calculations

Formatting Labels or Envelopes

Formatting Form-Letter Modules

Augmenting a Form Letter

Using GetField

Styling Text with Calculations

Updating Auto-Entry Serial Numbers

Chapter 5. Creating Data Reports

Extending a Found Set

Using Search Operators

Creating an "Inverted" Search

Creating Summary Layout Parts

Using Counts and Averages

Creating a Page Count

Creating Running Totals

Creating Sub-Summary Reports

Sorting Data for Sub-Summary Reports

Exporting Summary Data

Chapter 6. Creating Relationships

About Relationships

Relationship Terminology in FileMaker Pro 7

Defining a Match Field

External File References

Creating a Match Field in the Current Table

Lookup vs. Related Fields

Using a Match Field to Choose a Related Record

Repeating vs. Related Fields

Creating Portals

Creating Related Data with Portals

Sorting Data in Portals

Summarizing Related Data

About Self-Relationships

Using a Portal for Navigation

Searching for Self- Relationship Data

Creating a Lookup with a Self-Relationship

Using Multi-criteria Relationships

Chapter 7. Creating Simple Scripts

Planning a Simple Script

Using ScriptMaker

Creating a Basic Script

Editing Scripts

Managing Scripts

Creating Sub-Scripts

Combining Sub-Scripts

Extending or Constraining Found Sets in a Script

Exporting Records in a Script

Adding Comments to a Script

Using External Scripts

Chapter 8. Working with Conditional Script Steps

About Conditional Steps

Using the If Command

Using If with Else

About Get Functions

Using Get Functions with If Steps

Using Loop in a Script

Using Counters to Control Loops

Controlling Scripts with User Input

Creating Custom Dialog Boxes

Customizing Documents with If Steps

Chapter 9. Extending the Interface with Scripts

To create a layout for searching

Creating Script Buttons

Creating Interactive Buttons

Deleting Records in a Related File

Creating a Main Menu Layout

Linking to the Main Menu

Running Scripts from Fields

Creating Interactive Error Messages

Disabling Toolbars

Using Script Parameters for Multipurpose Scripts

Chapter 10. Script Troubleshooting

Testing Finished Scripts

Fixing Typical Errors

Debugging Scripts

Creating an Error Trap Script

Importing Scripts

Chapter 11. Filemaker and Other Programs

Using Scripts to Send Email

Using Scripts to Send Bulk Email

Using a Script to Open URLs

Exporting Data to Stati203 Tables

Exporting Formatted Text

Using Excel Data in FileMaker

Import from Excel Ranges

Using AppleScript with FileMaker Scripting

Exporting Field Contents

Copying the Contents of Records

Chapter 12. Importing Data

Importing Data from Text Sources

Batch-Importing

Batch-Importing from a Digital Camera (Mac OS X Only)

Importing with Scripts

Setting the Next Auto-Entry Serial Number

About FileMaker Mobile

Setting Up or Upgrading FileMaker Mobile

Synchronizing from Mobile to Pro

About XML

Exporting from FileMaker with XML

Importing into FileMaker with XML

FileMaker, XML, and the Web

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

About Importing ODBC Data

Storing SQL Commands in Scripts

Creating Dynamic SQL Queries

Chapter 14. Data Importing and Repairing

Cleaning Up Text Data Before Importing

Finding Duplicates

Importing Data Without Duplications

Troubleshooting Problem Data

Replacing Inconsistent Formatting

Separating Parts of Data

Chapter 15. Migrating To Version 7

FileMaker Editions

Pre-Conversion Issues

Cleaning Up a Database Before Conversion

Converting a Simple Database

Consolidating Multiple Related Files

Cleaning Up After Conversion

Sorting Case- Sensitive Data

Security Settings for Converted Files

Chapter 16. Multiuser Files On A Network

Setting Up Multiuser Files

Hiding Related Files

Creating an Opening Script

About Security Settings

Creating a User Account

Restricting Access with Privilege Sets

Setting Access Privileges by Password

Changing Password Access

Accessing Databases over the Internet

Chapter 17. Instant Web Publishing

About IWP

Converting Pre-v.7 Web Databases

Configuring Databases for Web Access

Accessing a Database with a Browser

Managing Database Access

Limiting Web User Options

Setting an Initial Layout

Linking to IWP Databases

Tracking Activity and Access

Disconnecting Inactive Users

Adapting Scripts for Web Users

Suppressing the Built-In IWP Interface

Creating Web Layouts

Creating a Web-Based Find Script

Web Display Considerations

Testing Your Web Database

About Custom Web Publishing

Appendix A. Filemaker and Third-Party Software

Network Integration

Fax and Email

Plug-Ins and Utilities

Interface Design

Appendix B. Filemaker Resources

Books

Web Pages

Mailing Lists

Usenet

Periodicals

User Groups

FileMaker Hosting

Index