FileMaker Pro on Mac OS 9: Database Management

During the late 1990s and early 2000s, FileMaker Pro (primarily versions 4.0 through 5.5) served as the premier desktop and workgroup database management system for Apple’s Mac OS 9. By bypassing the steep learning curves of traditional SQL engines, FileMaker Pro enabled both novice users and business professionals to design, deploy, and share relational databases through an intuitive, graphical user interface tightly integrated with the classic Macintosh operating system.

Integrated Development and Data Storage

Unlike enterprise database engines that separated the storage back-end from the user-facing front-end, FileMaker Pro bundled the database engine, business logic, and graphical interface into single standalone files (using the .fp3 and later .fp5 formats).

Interaction revolved around four primary operating modes:

  • Browse Mode: For entering, viewing, and navigating actual data records.
  • Find Mode: For querying data using form-based search requests directly within field boundaries.
  • Layout Mode: A WYSIWYG canvas for designing data entry screens, printable reports, and shipping labels with drag-and-drop elements.
  • Preview Mode: For viewing dynamic page breaks and calculations prior to printing.

Relational Capabilities and Portals

While early versions were purely flat-file, the iterations running on Mac OS 9 featured a full-fledged relational model. Relationships were established visually by matching unique key fields between distinct tables or separate database files.

To display related data, FileMaker Pro utilized "Portals." A portal allowed a layout based on one file (such as an Invoices database) to display a scrollable list of related line items from another file (such as Invoice Items). This simplified master-detail architecture without requiring manual SQL JOIN statements.

Multi-User Networking on Classic Mac OS

FileMaker Pro provided built-in, peer-to-peer sharing over local networks without requiring dedicated server software for small teams. On Mac OS 9, it natively supported both AppleTalk and TCP/IP networking protocols.

A single workstation running Mac OS 9 could act as a database host simply by enabling network sharing in the preferences. Other client workstations on the local network could discover and open the hosted files using the "Hosts" dialog. The software managed record-level locking automatically: as soon as one user clicked into a field to edit a record, that specific record was locked to all other network users until the edit was committed, preventing data collisions. For larger multi-user setups, FileMaker Server running on a dedicated Power Macintosh handled hosting, automated backups, and cache management.

Automation and ScriptMaker

Workflow automation was achieved using ScriptMaker, a visual programming environment tailored to Mac OS 9. Instead of typing out code, developers constructed scripts by selecting from pre-defined actions such as navigation, performing complex multi-criteria finds, exporting records, and setting field values.

ScriptMaker also integrated deeply with the Mac OS 9 ecosystem through AppleScript. Database actions could trigger external Mac OS 9 applications, mount shared network volumes via Chooser protocols, and automate repetitive desktop tasks.

Web and Media Integration

FileMaker Pro on Mac OS 9 offered specialized fields known as "Container" fields. These stored multimedia elements natively supported by the classic Mac OS, such as PICT graphics, EPS files, sounds, and embedded QuickTime movies.

Additionally, the software included the "Web Companion" plug-in. This feature turned a Mac OS 9 computer into a lightweight web server. Users could expose their databases to standard web browsers over HTTP using either Instant Web Publishing (pre-formatted HTML views) or Custom Web Publishing using FileMaker’s proprietary Claris Dynamic Markup Language (CDML).