From the course: FileMaker: Relational Database Design
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Primary and foreign key fields - FileMaker Pro Tutorial
From the course: FileMaker: Relational Database Design
Primary and foreign key fields
- [Instructor] Once you've completed your data modeling exercise, you will have determined what tables you're going to need in your FileMaker database, as well as what relationships you're going to have between those tables. So before we can define these inside the FileMaker database application, what we're going to need is some way that we can hook or link the two tables together in a relationship. And in relational databases the way you connect two related tables together is by using special fields that are defined in each table called keys. The keys will act as the link between two tables, thus creating a relationship that FileMaker needs, and also providing FileMaker as an application with the important information that it needs so it can determine how records are related within those tables. So a key is really just like any other field that you'd find in your database. But unlike other fields, they're going to perform special functions. Keys come in two different types, and each…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.