Chapter 11. Data Modeling in FileMaker

FileMaker is as much a problem-solving tool as it is a development platform. As such, it provides you with the means to achieve a wide variety of ends (and in the process, solve many problems). How you use the tools FileMaker makes available is less important than the functionality your solutions are able to deliver. Nevertheless, considering the underpinnings of a well-formed relational data model is helpful — not so much so that you will be bound to adhere rigidly to it, but so that you'll be able to make informed choices about how and when to depart from it.

Regardless how you choose to work in FileMaker, you need a clear plan for the storage of data, including the main connections and interactions between different data types. This over-arching plan is your data model. It doesn't matter where it exists — it could be in your solution itself, on a whiteboard in your office, on a diagram in your diary, or a vision in your imagination. However, without such a plan, ...

Get FileMaker® Pro 10 Bible now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.