Global Join Manager
|System Administrator Only|
The Global Join Manager displays all global joins in your Infor CRM database, and permits the system administrator or administrative user to add, edit, and delete global joins as necessary. A global join is permanent and exists from session to session in the Query Builder data tree structure.
Infor CRM contains a series of predefined global joins (called
system joins), which cannot be deleted.
The Global Join Manager is only available if you are logged in as an administrator.
- Open the Query Builder, and then click the Global Joins button.
This button only appears if you are logged on as Admin
Add a Global Join <![CDATA[ ]]>
Edit a Global Join <![CDATA[ ]]>
The Global Join Manager displays the following fields:
|Sys||A system join that cannot be deleted.|
|1:1||Indicates a one-to-one relationship.|
|Parent Table, Parent Field||The main table and field in the join relationship.|
|Child Table, Child Field||The table and field joined to the Parent Table and Parent Field.|
|Type||The type of join, such as Inner, Left, or Right.|
|Cascade||How records are deleted through the join.|
|Visibility||How the join displays in Query Builder.|
What's New in this Release
For a list of new features, see the What's New In This Release topic.
Getting Started with Infor CRM Web Client
Infor CRM Quick Reference for the Web User
This documentation was developed by Infor CRM User Assistance. For content revisions, questions, or comments, contact the Infor CRM writers at email@example.com.