Adding a Global Join

System Administrator Only

A global join is permanent and exists from session to session in the Query Builder data tree structure. Be very careful when creating global joins. You can inadvertently create a global join that causes severe performance problems.

To add

Open the Query Builder, and then click the Global Joins button.

This button only appears if you are logged on as Admin.

In the Global Join Manager dialog box, click Add.
In the Add Global Join dialog box, under Parent Table and Join Field, select the table and field for the global join.
Under Child Table and Join Field, select the table and field to join to the parent table and field.
Under Join Type, select the type of join.

The default is Left.

Under Join Options:

Select a Visibility option to specify how the join displays in the Query Builder.

The default is Allow.

Select a Cascade Type to specify how records are deleted through the join.

The default is Ignore (Do not use in cascade).

Click OK.