Database Reference
In-Depth Information
fields and then see a list of invoices that fall between the dates they enter. You'll call this lay-
out an Invoice Finder.
Creating the Invoice Finder Layout
To set up your new Invoice Finder layout, you need to add two new global fields to your
Globals table. You also need a new relationship that matches fields in the Invoices table us-
ing these global fields. This sort of job benefits from its own table occurrence group. Call
this group
Invoice Finder
.
To get the portal to show the right invoices, you need a relationship that uses your new glob-
al fields, and it'll have slightly more complicated rules than you've seen before. See
Fig-
ure 14-21
for the setup.
TIP
If the logic in
Figure 14-21
is confusing, remember that if you temporarily move the Invoice
Finder__GLOBALS TO to the right of Invoice Finder_INVOICES so that the relationships read
Date ≥ gStart Date AND Date ≤ gEnd Date instead. Then when you switch the Invoice
Finder__GLOBALS TO back to its anchor position at the left edge of the TOG, FileMaker switches
the logic for you.
