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 instructor 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 Pro from 16 through the most current version.
Topics include:
- Diagramming your relationships
- Problems caused by many-to-many relationships
- Adding a join table
- Defining primary and foreign key fields
- Working with relationships and queries
- Creating child records
- Using advanced relationship techniques
Most of the courses are paid courses ...
You can also check the discounts made by Udemy from time to time !