Common
Add Table Join Relationships
Table join relationships indicate how table fields are connected. Table join relationships must be manually added to System Types.
To add table join relationships:
- Click Common > System Types in Navigation pane.
-
Click Tables icon for a System Type.
- Click Joins icon for System Type table.
-
Click Add.
- Select the table on left side of join from LEFT SYSTEM TYPE TABLE ID combo box.
- Select the table on right side of join from RIGHT SYSTEM TYPE TABLE ID combo box.
- Click Save.
- Click Fields icon for join.
-
Click Add.
View the field descriptions for the System Types Join Field page
- Enter order in which joins occur in PRIORITY field.
- Select the table field on left side of join from LEFT SYSTEM TYPE TABLE FIELD ID list box.
- Select the table field on right side of join from RIGHT SYSTEM TYPE TABLE FIELD ID list box.
- Select type of join from TYPE list box.
- Click Save.