Join Cris Ippolite for an in-depth discussion in this video Creating aggregate functions using relationships, part of Relational Database Design with FileMaker Pro.
- So far in this title, we've looked at…how to create relationships to establish…the architecture of our database,…and then how to use those relationships,…or even create specialized ones…to use with layout objects like…related fields and portals in our layouts.…We've also looked at incorporating…these relationships into our scripts.…In FileMaker, our architecture combined…with our scripts are a large part…of the scheme of our database.…But one important area of the schema…that we've not yet looked at are calculations.…Calculation fields and calculation dialogues…are found throughout the FileMaker interface…and they're there to add another dimension…to your FileMaker solution.…
And related fields can be used within…those calculations dialogues.…This can be a very powerful way to…leverage relationships to aggregate…related data throughout your database.…Let me show you a couple of examples.…These are easy to do and they can…give you a lot of value back…with very little overhead.…And the first example that I'm gonna do is…
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.