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 ID.…So it just so happens that the table…