FileMaker Fundamentals: Understanding Relationships

by Matt Petrowsky

Article options

• Watch Preview Video
• Watch Full Version
• Download Movie File

When you hear the word 'schema', and think about your database, you may think this deals with how your database is structured. While true, the data connections you make within the Relationship Graph are only one part of your whole solution.

You'll certainly have scripts which define the logical "use and flow" of how people interact with the data. Yet, the key to knowing how to structure your data schema is knowing what your options are and when to set them.

Part of knowing how to structure a database comes from knowing the options available, the other part comes from experience of knowing how to break out data so it fits the desired result - a true art derived from practice. There truly is no one single way of structuring the data because it depends on how it's going to be used.

This video takes a look at the basic setup of how data is most commonly stored and pushed around. You'll be provided with insight into the various possible options and provided with some tips about working within FileMaker's Relationship Graph.