Join Cris Ippolite for an in-depth discussion in this video Using primary and foreign key fields, part of FileMaker Pro: Relational Database Design (2011).
- 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…are going to be needed between those tables.…What you'll need in order to create relationships…is something that could link each related table together…so that each table has to have a little hook in there…that allows that connection.…In relational databases,…you're gonna connect two related tables together…using special fields defined in each table…and these fields are called keys.…A key field is just like any other field…that you're defining in your database,…but unlike these other fields,…they perform special functions.…
Key fields come in two different types…and each type has its own function.…There's the primary key and the foreign key.…These are two more pieces of vocabulary…that you're gonna hear a lot in this title,…so it's a good thing to understand what they are now.…Let's look first at primary keys.…A primary key is a field that gets defined in a table…
The course applies to versions of FileMaker Pro from 7 through the most current version.
- Reviewing relationships types
- Diagramming relationships
- Resolving many-to-many relationships
- Determining which tables need key fields
- Defining tables in FileMaker Pro
- Using the Relationship Graph
- Using multiple match fields in one relationship
- Using global fields to filter portals
- Creating self relationships
- Creating aggregate functions using relationships
Skill Level Intermediate
Q: The exercise files for this course do not work on a Mac. It downloads executable files. Can you provide a workaround?
A: The files provided for this course were made pre-FileMaker Pro 12. The system does not recognize the .fp7 files immediately as something that can be opened with FileMaker Pro 12 and instead shows them as Unix Executable Files.
The solution is quite simple. Just double-click the file, at which point the Mac will prompt you to choose an application to open the
file with. Select FileMaker Pro 12 and it will then convert the file from a .fp7 file into the new FileMaker Pro 12 file format, which is .fmp12.
Q: This course was updated on 5/12/2015. What changed?
A: We moved a video from the "Using Relationships" chapter of FileMaker Pro 13 Essential Training into this course, where it will remain evergreen.