From the course: FileMaker: Relational Database Design
Join today to access over 24,700 courses taught by industry experts.
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…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.