From the course: FileMaker: Relational Database Design
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Dashboards using relationships - FileMaker Pro Tutorial
From the course: FileMaker: Relational Database Design
Dashboards using relationships
- [Instructor] So I've been trying to drive home the importance of context in your relationships, and in this movie I'm going to kind of blow it up a little bit, but it's really all about context. What I'm going to do is introduce you to the concept of having a completely different context outside of the relational structure, and we're going to do so for the purposes of creating dashboards. So first of all, let's look at the tables that we have here. You notice that we've got the related tables that we've been working with so far in all our exercises. Then we've got this other table, dashboard. It's not related to any other table. It just kind of floats around out here. But much like every other table that's represented on this relationship graph, our base tables at least, it provides a context for doing other relationship techniques. So this one's going to provide a context as well. So for example, I've got this layout that's based on dashboard. That's the layout that you see here…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
-
-
-
-
(Locked)
Using global fields to filter portals6m 52s
-
(Locked)
Using global fields to create a user-driven portal filter4m 43s
-
(Locked)
Using relationships in a script to navigate4m 58s
-
(Locked)
Reviewing related data more than one site away2m 56s
-
(Locked)
Creating self relationships4m 40s
-
(Locked)
Creating aggregate functions using relationships4m 46s
-
(Locked)
Dashboards using relationships8m 20s
-
(Locked)
Cascading portals4m 56s
-
(Locked)
-