From the course: Advanced FileMaker Pro 12

Unlock the full course today

Join today to access over 22,500 courses taught by industry experts or purchase this course individually.

Using ranges in user-driven relationships

Using ranges in user-driven relationships - FileMaker Pro Tutorial

From the course: Advanced FileMaker Pro 12

Start my 1-month free trial

Using ranges in user-driven relationships

In the previous movie we discussed how to set up what I would like to call a user-driven relationship. So we've gone into our Relationship graph and created a couple of different relationships, one that went from what is called a Global Table Company Info, to the Invoices Table, and then from Invoice Table using Customers. But the real one here was this Relationship we created in the middle that allow the user to populate field that we call the DashboardFilter with either a Paid or Unpaid status. And then in turn what we did is put that field right here, the DashboardFilter and a Relationship based on the DashboardFilter, onto this Layout. So what we want to do now is add additional criteria to it. So not only are we are going to allow the user to pick Paid or Unpaid, but we are also going to allow them to pick the Start and End date of the range of Invoices that they would like to see. So we are going to further embellish the Relationship that we already created or the Query…

Contents