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

Using relationships in a script to navigate - FileMaker Pro Tutorial

From the course: FileMaker: Relational Database Design

Start my 1-month free trial

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…

Contents