Join Cris Ippolite for an in-depth discussion in this video Using global fields to create a date range filter, part of FileMaker Pro: Relational Database Design (2011).
- Using a globally stored field as a portal filter…for one of your relationships…can allow users to change the portal's perspective…within their session and thereby present users…with a set of Related Records of their choice.…Adding just one of those global fields as a filter…can control the value seen in the portal,…but adding two globally stored fields…as a pair of filters can present users…with a range of related values.…So for example, in this file that we've got here,…you'll see that we've got this portal for all future orders,…and right not all it does is use a relationship…that's already been set up in the file,…which is called customer_ORDERS_future,…and it shows all order records related to the customer,…but where the sale date value…is greater than today's date,…and today's date is stored inside each customer record…using the get function for the current date…as a calculation so that every customer record…has the same value,…but let's say that we'd like to…allow the user to pick a start date and an end date…
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.