Automating FileMaker Pro: Scripting, Calculations, and Data Transfer

FileMaker Pro is the world's most popular stand-alone desktop database software application. It runs on Macintosh and Windows and is used daily by people around the world for problems large and small.
It is unique among database products in that it has elegantly and (apparently) effortlessly made the transition from a single-user, nonrelational database to a multiuser, relational database that now has a sophisticated Web interface. Its ODBC functionality (introduced in version 4.1) and its new features in version 5 (including portable scripts a major advance) position it as the leader of the pack of products geared specifically to the small-business and workgroup marketplace. Whether you create databases for your own use, rely on others to create them, or create them yourself for use by others, FileMaker remains and most likely will continue to remain an important and invaluable tool (perhaps the only database tool that you will use).
Some people work their way up to FileMaker as they realize that their spreadsheet or word processor just isn't going to cut the mustard when it comes to keeping track of their collection of seashells, their student rosters, or their company inventory. Many of these people sit down at their computer with an empty FileMaker Pro database (or with one of the excellent FileMaker samples or templates) and take it from there.
Other people plunge into a full-blown FileMaker Pro solution that incorporates a custom-made database, a specially designed interface, and additional features such as links to other computer...