From the course: FileMaker: Relational Database Design
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Using relationships in a script to navigate - FileMaker Pro Tutorial
From the course: FileMaker: Relational Database Design
Using relationships in a script to navigate
- [Instructor] We've talked a lot about how powerful relationships and query relationships are in FileMaker, and we've seen how we can filter different data whether it's the user filtering or just building that criteria into our query relationship. A lot of it we've done by just visually looking at data inside of portals. Now I'm going to show you another technique where you can use a query relationship or relationship to navigate to data in another context. So first, I want to take a look at the context of this layout. So this layout is based on the order table, which means it's the order context. And you'll notice that I have a portal here that's based on order line item. And if we go into our relationship graph, we can see that the relationship between order and order line item is a parent-child. Order line item happens to be the join table, actually, that satisfies the many to many relationship between the orders and the products. But in this case, it's a simple PK to FK, a…
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
-
-
-
-
-
-
-
-
-
-
-
Using global fields to filter portals6m 52s
-
Using global fields to create a user-driven portal filter4m 43s
-
Using relationships in a script to navigate4m 58s
-
Reviewing related data more than one site away2m 56s
-
Creating self relationships4m 40s
-
Creating aggregate functions using relationships4m 46s
-
Dashboards using relationships8m 20s
-
Cascading portals4m 56s
-
-