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. You can inadvertently create a global join that causes severe performance problems.

To add

  1. From the Query Builder, click Global Joins.

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

  2. In the Global Join Managerscreen, click Add.
  3. In the Add Global Join screen, under Parent Table and Join Field, select the table and field for the global join.
  4. In Child Table and Join Field, select the table and field to join to the parent table and field.
  5. In Join Type, select the type of join.
    The default is Left.
  6. In Join Options:
    1. Select a Visibility option to specify how the join displays in the Query Builder. The default value is Allow.
    2. Select a Cascade Type to specify how records are deleted through the join. The default value is Ignore (Do not use in cascade).
  7. Click OK.
Related topics