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

Primary and foreign key fields - FileMaker Pro Tutorial

From the course: FileMaker: Relational Database Design

Start my 1-month free trial

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…

Contents