Join Cris Ippolite for an in-depth discussion in this video Using relationships in a script to navigate, part of Relational Database Design with FileMaker Pro.
- View Offline
- Once you've established some table relationships…inside your FileMaker file,…you can start benefiting from some of the relationship-based…functionality inside FileMaker.…We've already discussed in previous movies in this chapter…the ability to use related fields in your layouts,…which are basically borrowing a field value…from a parent table,…and you see here in this layout,…we've already discussed how we can add portals,…a layout object that allows you to see related child records…from the context of your parent record,…and now I'm gonna show you how…relationships can benefit you…outside of just using layout objects,…but instead, inside of your scripts.…
So first a couple of quick items,…if you're not already familiar,…a script is something in FileMaker…that allows you to save stored actions, any sequence,…and allow them to be triggered by some user action.…Scripts can be set up under the Manage Scripts dialog.…You create a script and choose…from a series of different script steps.…What we're going to do here is create a script,…
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