FileMaker: Relational Database Design [Updated: 1/8/2025]
.MP4, AVC, 1280x720, 30 fps | English, AAC, 2 Ch | 2h 40m | 332 MB
Instructor: Cris Ippolite
.MP4, AVC, 1280x720, 30 fps | English, AAC, 2 Ch | 2h 40m | 332 MB
Instructor: Cris Ippolite
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.
Learning objectives
- 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