Ternary and Higher Order Relationships

Ternary and higher relationships is an advanced feature of C1Query allowing you to exercise finer control over joins applied to three or more tables (views) appearing in a query.

In most cases, when three or more tables appear in a query, they can be joined by corresponding binary relationships between pairs of tables. Sometimes, however, joins between two tables may depend on which of the other tables is actually present in the query. In this case, you may consider defining a higher order relationship. Select the Advanced (ternary or higher) radio button to indicate that a relationship is a higher order one.

A higher order relationship is applied only if all its constituent views are present in the query. The joins of a higher order relationship are specified in exactly the same way as in a binary relationship. The only differences are that you add views using the Add view button in the Relationship Designer (not in combo boxes, since there are more than two views), and there is a separate value in the join type combo box for every adjacent pair of views in the relationship.