Database Reference
In-Depth Information
Figure 14-21. The relationship between Invoice Finder__GLOBALS and Invoice
Finder_INVOICES connects two global date fields to one regular date field. An invoice has to be
between the value in the gStart Date field and the value in the gEnd Date field to show up in the
portal you create using this relationship. Read out loud: “These relationship criteria say that an in-
voice will match if its date is on or after the global start date, and if the date is on or before the
global end date.” As with all relationships based on global fields, it works normally from the “left”
side to the right side but isn't truly bidirectional. Both fields have to have a valid date in them be-
fore any records show in the portal.
Below are the steps for creating a new table, defining some global fields in that new table
and then using your creations in a new table occurrence group. You've done most of this
stuff before in other tutorials, so although you have to follow a lot of steps, they should all be
familiar:
1.
In the Invoices database, go to the Manage Database window's Fields tab and se-
lect your Globals table. Then, in the Field Name box, type
gStart Date
. Make the
field a Date type and then click Create
.
The “g” prefix reminds you that the field is a global.
