Create joins (optional)
- Click the Joins tab.
- To create a join, drag your originating column in the primary table to the target column in the secondary table. The join is displayed as a gray line connecting the two columns together. (You may have to scroll to the right to see the selected tables)
- You can specify the type of join. Right-click the join and select Specify Join Type. In the Specify Join window, click Inner Join or Left outer join.
- You can remove a join. Right-click the join and select Remove Join.
If the base table is joined with the primary key of another table, the relation is one-to-one and the selected columns are single valued. In other cases, columns are multi-valued. For multi-valued cases, when more than one column in the association table is selected, it is a compound multi-value. The wizard generates a bean for these columns and the multi-value will be an array of this bean. The name of this bean is based upon the display name of the secondary table.
Back