Skip links

Introduction to FileMaker - Part 1

FileMaker training, courses, coaching

In the first part of the introduction to FileMaker on goFileMaker, I explain what FileMaker actually is, where FileMaker comes from and what you can do with the software. Simply put, FileMaker is a database software that can be run under Apple Mac OS X as well as Windows XP, Vista and Windows 7. FileMaker can be used to manage all kinds of data in a wide variety of ways - from simple DVD management for a private individual to the complex Merchandise management system With hundreds of connected users, anything is possible with FileMaker.

The original FileMaker was created under MS-DOS

FileMaker software has a long and eventful history. It all started with the software "Nutshell" under MS-DOS in 1982, which was developed by Nashoba Systems and distributed by the company "Leading Edge". When the first Apple Macintosh saw the light of day in 1984, Nashoba continued to develop its software for the Mac's new graphical user interface. Nashoba then renamed this software "FileMaker" and had it distributed by the company Forethought. In 1987, Microsoft bought the distributor Forethought, so Nashoba decided to further develop FileMaker to version 4 and distribute it himself from then on. Shortly afterwards, Nashoba was taken over by the Apple subsidiary Claris and brought the software onto the market under the name "Claris FileMaker II". In 1990, Claris released the first version of FileMaker Pro. This software made it possible for the first time to change the database structure and fields used during operation. In 1993, FileMaker Pro 2.1 was released, which was also available for Windows for the first time.

Relational databases with FileMaker 3.0

Up to version 2.1, FileMaker was a flat database system, i.e. a Database always consisted of exactly one data table with fields that could not be linked to each other. With FileMaker 3.0 it was possible for the first time to link several FileMaker files (tables) relationally. What exactly does that mean?

Let's assume you want to develop a customer database. You want to be able to store any number of contact persons per customer in your database. In a flat database, "any number" would not be possible - you could create a maximum of 10 fields for possible contact persons, for example. This would allow you to enter up to 10 partners per customer, but not as many as you like. In a relational database system, however, this would be possible without any problems by simply creating two tables - one for the address master and a separate one for the contact persons. Both tables contain a so-called key field - in this case, for example, the address number. The two data tables are now linked to each other via this key field. If the address number is identical in one data record of both tables, the data records belong together. As it does not matter how many data records with identical address numbers are in the Table for the contact persons, any number of contact persons can be assigned to each address in a relational database.

From version 4.0 of FileMaker, the software had the option of importing data from external data sources via the ODBC-Interface import. At that time, a new company was founded called FileMaker, which has been developing and distributing FileMaker products ever since. By 2001, FileMaker 5.0 and FileMaker 5.5 had been released, each with further innovations. With FileMaker 6.0, it was possible to import and export XML data for the first time in 2002. Until FileMaker 6.0, the *.fp5 file format was used, which allowed exactly one data table to be created per file.

Multiple tables per file and Unicode as of FileMaker 7

The seventh version of FileMaker heralded a new era in 2004 - this software was reprogrammed from scratch, the entire data model was revised and the functionality of the software was greatly expanded. The one-dimensional relationships from FileMaker up to the sixth version have been replaced by multi-layered relations between table occurrences. From version 7 onwards, the relationships are now displayed in a graphical relationship diagram (entity relationship). Data from other database files can now also be displayed in screen or print layouts. The maximum file size has been increased from 2 gigabytes to 8 terabytes.

Since FileMaker 8, it is possible to define your own functions (Custom Functions) in a FileMaker file, which also support recursive calls. From version 8.5, HTML content in web viewer containers can be displayed directly in a layout.

With the ninth version, fields and field contents could be formatted in FileMaker depending on the content. In addition, since this version, external SQL-data sources (e.g. Microsoft SQL-ServerIBM AS/400, Oracle, MySQL etc.) can be connected to FileMaker databases in real time, a search function has been added to the script editor, and most windows in FileMaker can be scaled as required.

In 2009, FileMaker 10 was released with a newly developed user interface, an extended search function, easier report creation and additional import and export formats, particularly in relation to Microsoft Excel and FileMaker Bento. Since FileMaker 10, it has also been possible to send emails directly via a built-in SMTP server.

The current version 11 of FileMaker allows the visual presentation of data in simple diagrams and offers a cross-field Quick searchsimilar to Spotlight in Apple Mac OS X.

Versions of FileMaker

FileMaker is distributed in different versions, each of which is available for Apple Mac OS X and Microsoft Windows:

FileMaker Pro - FileMaker Pro is the "standard version" of FileMaker, which can be used for standalone applications or as a client in the Network is best suited. FileMaker Pro allows the sharing of databases for up to 10 simultaneous FileMaker users in the network as well as the sharing of databases on the web via Instant Web Publishing.

FileMaker Pro Advanced - This enhanced version of FileMaker Pro includes additional developer features such as Database Design Reports (DDR), a Script-debugger, the definition of your own functions (Custom Functions) and the creation of your own menus. FileMaker Pro Advanced also makes it possible to create independently executable databases (FileMaker Runtimes) for Mac OS X and Windows, which can be distributed license-free in any number, but are not network-compatible and do not support SQL functions.

FileMaker Server - With FileMaker Server, databases can be shared with up to 250 users in the network. FileMaker Server requires a dedicated computer running Windows or Mac OS X.

FileMaker Server Advanced - This server version can provide FileMaker databases for any number of users in the network. In addition, administrator groups can be created, and the software supports server-based Instant Web Publishing and allows access to FileMaker databases via ODBC or JDBC.

FileMaker Go - With FileMaker Go, FileMaker databases can be used on an Apple iPad or iPhone. These can either be transferred locally to the corresponding iPad or iPhone (or iPod touch), or FileMaker Go accesses a FileMaker server via a wireless network. It is not possible to create new databases in FileMaker Go.

* * *

Find out in the second part of the introductionThe following topics are covered: what elements a FileMaker database contains, how to start developing databases, where you can obtain ready-made templates for further development and which models are best suited to using FileMaker databases.

FileMaker training and coaching from goFileMaker

Would you like to delve deeper into the subject of FileMaker database development or do you already have your own FileMaker solution that you would like to develop further? With our coaching and training services, we are happy to help you with the development of FileMaker databases nationwide via telephone and remote maintenance. We will be happy to discuss your individual requirements in a personal meeting. To book a FileMaker coaching session, you can simply order the desired number of hours in our online store and let us know your preferred date in the order comment. We are also happy to advise you in advance by e-mail at info@gofilemaker.de.

All previous parts of the introduction FileMaker

Part 1: Historical background and versions

Part 2: Practical part with creation of an address database

Part 3: Layouts, navigation, buttons, QR codes

Part 4: Fields and formulas, relationships, scripts, custom functions, plugins, SQL

Leave a comment

Share this page:

ERP software as flexible as your company.
We will be happy to advise you.

Customizable ERP software for Mac, Windows and iOS.

You are here: Introduction to the FileMaker database system for Mac OS X and Windows. Part 1 with historical background | goFileMaker