Understanding which data tables to create and how to link them together via relationships is key to mastering the relational database capabilities of FileMaker Pro.
In this course, join three-time FileMaker Excellence Award winner Cris Ippolite as he shows how to translate aspects of the real world into the form and language of a relational database.
Cris begins by reviewing some of the basic concepts of data modeling, introducing tables, key fields, and the relationship graph.
After demonstrating how to establish relationships in a database, he discusses using these relationships in portals, in calculations, and while navigating.
He also includes three practical data modeling examples to help you grasp how these concepts work in the real world.
This course applies to versions of FileMaker through the most current version.
Advanced Relationship techniques, Working With Queries