• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 7. Working with Relationships > Creating Ranged Relationships

Creating Ranged Relationships

FileMaker Pro's new non-equijoin feature has a great number of uses—too many to cover exhaustively. We'll touch on a couple more before moving on. An earlier example, looked at a relationship that let you look at a customer's invoices for the current year only. What if you wanted to refine those criteria further, and look at invoices for just the first fiscal quarter (January through March)?

Let's return to the Invoicing example (shown in Figures 7.4-7.9). The first “date-filtering” relationship was created when a calculation field was added in the Customer table to produce the start of the current year. For this new query, you need to add one more calculation field—one that will give you the end of the first quarter. This one is also quite simple; the new calculation is shown at the end of the field list in Figure 7.21.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint