From the course: FileMaker Pro 15 Essential Training

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Understand key fields

Understand key fields - FileMaker Pro Tutorial

From the course: FileMaker Pro 15 Essential Training

Start my 1-month free trial

Understand key fields

- [Voiceover] So once you've completed the data modeling exercise, you will have determined what tables you're gonna need in your FileMaker database, as well as what relationships you're gonna need between those tables. Now what we're gonna need is some way to establish a link, or a hook, between these two tables in the relationship, and we need that because ultimately that's what we're gonna use to build the relationship in FileMaker, and that of course is gonna be our next step here. In relational databases, you're gonna connect two related tables together using special fields defined in each table, and these special fields are called keys. Key fields act as links between the two tables, and structurally we'll have to actually define key fields in each one of the tables that have a relationship when we go into FileMaker and build these out. Now the role that a key field plays is between two different tables, so let's say we have a customers table and an invoices table. We need…

Contents