Database Reference
In-Depth Information
TIP
If you prefer, you can convert a single criterion relationship to a multiple criteria one by dragging
between a new pair of fields. But you always get an = operator for this second pair, and the Edit
Relationship window doesn't open automatically when you do. So if you need anything nonstand-
ard, you may as well just open the Edit Relationship window straightaway.
Figure 14-4. Several concepts are illustrated here. First, the box between Invoices and In-
voices_currentJob has a sort of squared-off infinity symbol instead of an equal sign, like all the
rest. That tells you that the relationship is a multi-criteria relationship. Second, you can see a new
relationship has been created so you can use it to sum up all the invoices for each job. Third, the
layout behind the dialog box shows the two sum fields and how you can arrange them so that the
portal's data makes sense.
Relationship Operators
As you learned in the last section, sometimes you want a relationship to work when the val-
ues in key fields are different. But you might also want to show all Invoices after a particular
date. In that case, you want to match dates when the values are greater than (>) or greater
than or equal to (≥) the value in a key field. Here's a list of all the comparative operators:
