Adding or modifying Global Joins in database manager

The Database Manager allows the administrator to add or edit a global join from the Global Joins tab and the Tables Global Joins tab.

Note: The system administrator can only access these features. These features are not available in Oracle environments.

To add or modify a Global Join:

  1. Select Administration > Database Manager on the navigation bar. Click the Global Joins tab. The Global Joins list view is displayed.
  2. Click New Global Join in the Task pane to add global join. The Create Global Join window is displayed.
    Note: You can also:
    • Click the Tables tab and select the table to add the global join. Click Global Joins tab in the details view and click Add to add a new global join.
    • Click the Tables tab and select the table that contains the global join to edit. Click the Global Joins tab in the details view. Click Edit to edit a new global join for the selected global join.
  3. Specify this information:
    Parent Table
    The main table in the join relationship. Click the drop-down arrow and select a table. System global joins cannot be edited.
    Parent Field
    The main field in the join relationship. Click the drop-down arrow and select a field from the list of fields for the selected parent table. System global joins cannot be edited.
    Child Table
    The table joined to the parent table and field. Click the drop-down arrow and select a table. System global joins cannot be edited.
    Child Field
    The field joined to the parent table and field. Click the drop-down arrow and select a field from the list of fields from the selected child table. System global joins cannot be edited.
    Visibility
    Determines how the join displays in Query Builder. Click the drop-down arrow and select an option from the list. See Visibility Options
    Cascade Type
    Determines how records are deleted through the join. Click the drop-down arrow and select an option from the list See Cascade options
    Join Type
    The type of join. Possible Values:
    • Inner: Include only records where the joined fields from both tables are equal. See Inner joins
    • Left: Include all records from the Parent Table and only those records from the Child Table where the joined fields are equal. See Left Joins
    • Right: Include all records from the Child Table and only those records from the Parent Table where the joined fields are equal. See Right Joins
    System
    If this check box is selected, the join cannot be deleted and the parent and child tables and fields cannot be edited. This identifies if a global join is created by Infor CRM SLX.
    1:1
    Indicates a one-to-one relationship between the parent and child tables and fields. This option cannot be edited once the global join is created.
  4. Click OK.
Related topics