Create a join field
- Last UpdatedApr 08, 2025
- 2 minute read
Use the Join Fields editor to create linked fields between a secondary and primary table.
Specify join type for a custom view
When the join type is Inner, all data from the primary table is included in the custom view, and only data from the secondary table that matches on join fields. When the join type is Outer, all data in both tables is present in the custom view. Also, when the join type is Outer, you can group on fields that originate from the secondary table, in addition to fields from the primary table. Use the JoinType property on the secondary table to specify the join method between primary and secondary tables.
-
Inner- You can group on fields that originate from the primary table.
-
Outer- You can group on fields that originate from the primary table and the secondary table.
To create join field
Join each secondary table to a primary table through a join field.
Important: It is important to use compatible data types when you join fields because AVEVA™ Production Management does not verify compatibility.
-
Select a secondary table.
-
In the Properties pane, click Browse (...) next to the JoinFields property. The JoinField Collection Editor appears.
-
In the JoinField Collection Editor, click Add. A new join field appears in the left panel.
Specifying the join field properties
-
PrimaryField - Select a field from the primary table.
-
SecondaryField - Select a field from the secondary table.
-
-
Click Add again to add more joined fields if required. There is no restriction on the number of join fields.