Join Cris Ippolite for an in-depth discussion in this video Defining key fields, part of FileMaker Pro: Relational Database Design (2011).
- In order to create relationships in FileMaker,…you first need to determine…which tables you're gonna have in your database,…and then create those tables.…As you'll see in your Exercises Files,…if we go in to the 04 02 files,…and under the File, Manage, and Database,…you'll see that we've already got…four tables created inside of our database.…It's one table for each entity that we've identified…throughout our data modelling exercise.…In that exercise,…we identified that we had four different entities,…Products, Orders, Customers, and OrderLineItem,…and we've created a table for each of those here.…
By evaluating the one-to-many relationships…between each of these tables,…we determine that every child table…in a one-to-many relationship,…which is on the many side,…will need to have a foreign key field,…and every parent,…which is the one in the one-to-many,…will need to have a primary key field defined.…We look it at our relationships here,…we see that we've got relationships…between Products and OrderLineItems,…
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.