Using the database manager global joins CRM Details tab

The Database Manager Global Joins tab allows the administrator to manage database global joins. In the detail pane, the CRM Details tab allows the administrator to view and edit the properties. You can also view global joins for a specific table on the Table Global Joins tab. See Using the database manager table Global Joins tab

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

To open the Table CRM Details tab:

  1. Select Administration > Database Manager on the navigation bar. Click the Global Joins tab. The Global Joins list view is displayed.
  2. Click the CRM Details tab.
  3. View or modify the following information:
    Parent Table
    The main table in the join relationship. To edit, click the drop-down arrow and select a table. System global joins cannot be edited.
    Parent Field
    The main field in the join relationship. To edit, 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 Parent Field. To edit, 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 Parent Field. To edit, 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. To edit, 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. To edit, click the drop-down arrow and select an option from the list See Cascade options
    Join Type
    The type of join.
    • 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: Identifies if a global join was created by Infor CRM SLX. If selected, the join cannot be deleted and the parent and child tables and fields cannot be edited.
    • 1:1: Indicates a one-to-one relationship. This option cannot be edited after the global join is created.