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.

Using global fields to filter portals

Using global fields to filter portals - FileMaker Pro Tutorial

From the course: FileMaker: Relational Database Design

Start my 1-month free trial

Using global fields to filter portals

“

- [Narrator] In this chapter, I'm going to share with you a couple of relationship techniques, some stuff that I think should be in the old FileMaker tool belt. This one in particular, I think, is really useful, and what I've left here on screen is three different portals. The portal on the left is just a relationship that's based on the relationship between the customer's parent table and the order's child table, and then you see we have these two queries that are set up. The query relationship between customers and orders that identifies just shipped records, and then the query relationship between customers and orders that just shows future orders. But I'm going to show you a way that you can let your users determine what shows up inside of a portal. It's a pretty easy technique referred to commonly as portal filtering. So first of all, let's remind ourselves of the criteria when we set up relationships, or query relationships, inside FileMaker. You'll notice here that we had to…

Contents