Help on Specifying a Join Path

You can specify a join path when there is more than one way to get to the entity from the same join table specified for the relationship. For example, in a relationship called Sell, an entity is Branches. The join table is the table Sales. There is more than one way from the table Sales to the table Branches.

The two ways to get to the entity are:

• Join from the table Sales using the field Branch_id to the table Branches.

In other words, use the join Sales.branch_id~Branches.id

• Join from the table Sales using the field Salesrep_id to the table Salesreps, and then join from Salesreps using the field Branch_id to the table Branches.

In other words, use the join Sales.salesrep_id~Salesreps.id followed by the join Salesreps.branch_id~Branches.id

You can select either of these paths from this dialog box.