On September 14th, 2017, we published revised versions of our Privacy Policy, Terms of Service and Website Use Policy and published a Cookie Policy. Your continued use of Lynda.com means you agree to these revised documents, so please take a few minutes to read and understand them.

Understanding key fields

- Once you've completed your data modeling exercise,…you'll have determined what tables you're going to need…in your FileMaker database,…as well as what relationships that you're going to need…between those tables.…Now before you can actually go define these fields…in FileMaker, you have one more step.…And that is you need to figure out some way…that you can link, or hook, the two tables…together in a relationship.…They need to have something in common with each other…in order to create a link.…In relational databases,…you're going to connect two related tables together…using special fields defining each of these tables,…and those special fields are called Key Fields.…

These keys will act as a link between two tables,…thus creating a relationship that FileMaker's going to need.…A key field is just like any other field…that you would find in your database,…but unlike other fields,…these are going to perform a special function.…The keys are going to be the hook…that links the two tables together.…Keys come in two different types…

Resume Transcript Auto-Scroll

Author

Released

5/12/2015

Learn how to design and build smart, secure databases with FileMaker Pro 14—the database solution used everywhere from home offices to Fortune 500 companies all around the world. Cris Ippolite, drawing on years of experience with clients at his own development firm, iSolutions, walks through the essential FileMaker Pro skills, from creating tables and fields to designing layouts that display your data in a smart way. He'll also show you how to find and sort data, create reports, import and export data, write scripts, diagram relationships, and more. Watch now to start learning how to build your first database from scratch.