Beginning FileMaker 01 - Designing a Database

The web offers many sources for FileMaker training, including books, videos, and blog posts. However, the concepts can be overwhelming for newcomers. In this series of posts I’m going to document my thoughts on what order makes the most sense to me, and link to some resources that I’ve found useful. Please feel free to add your thoughts, comments, and edits.

To begin, I found this article on designing a relational database very useful for explaining the concepts of tables, attributes, and relationships.

https://help.claris.com/en/pro-help/content/planning-databases.html

It is a good starting point, indeed.

From there, we can explore the concepts of normalisation & de-normalisation. The latter brings us to performance core principles, which are expanded here:
https://the.fmsoup.org/t/performance-core-principles-3-relationships/1859

2 Likes