Join Cris Ippolite for an in-depth discussion in this video Personnel management example, part of FileMaker Pro: Relational Database Design (2011).
- In this movie, we're gonna use another real-world example…to apply what we've already learned…about modeling relationships.…But this time we're gonna examine…one-to-one relationships and the concept…of a self-join table using an instance.…Now remember, a relationship modeling…breaks down into three different phases.…First you develop a list of entities…or tables that belong in the data model.…And then next you determine and diagram…those relationships between the entities.…And then finally, review the diagram…for correctness and consistency…and revisit steps one and two, if necessary.…
Here's another process description.…And remember, when looking for entities…you want to look for nouns in your description.…So go ahead and pause this movie…and take a minute to read this through.…Using the nouns technique, we can identify the entities here…as employees, benefits, and managers.…Each of these appear to be different,…discreet types of data, and each can be…described differently from the others.…Let's also make a note of the phrase…
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.