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.

Define primary and foreign keys

Define primary and foreign keys - FileMaker Pro Tutorial

From the course: FileMaker Pro 15 Essential Training

Start my 1-month free trial

Define primary and foreign keys

- [Voiceover] So you've done everything you need to do, you've planned out your database ahead of time, you've figured out what tables you're gonna need, you've gone through the modeling process, which is your blueprint, to tell you not only what tables you're gonna need to find in FileMaker, but how those relationships are gonna be defined, and then you've done the really important last step of the blueprint or the data modeling process, and in your entity relationship diagram, you've determined what key fields you need. So now we wanna define those key fields in our tables so that we can move on to the final step which is actually creating the relationships in FileMaker. So before we do any of the other fields, we're gonna create these key fields. Now keep in mind we imported in the products table, so it's already got a bunch of fields in it, as a matter of fact, the products table has a ton of different fields, and one of them that it's got here on the bottom is this PK products…

Contents