Creating Table Joins

Access the JD Edwards Business View Design Aid form.

1. On the Tables Joins form, click and draw a line that connects a column in the primary table to an associated column in a secondary table.

   Although the column names do not have to be the same, the attributes for Data Type and Decimals must be identical before you can create a table join between two columns. To determine whether data items are candidates for a join, click a data item on the Table Joins form and view the data item attributes that are displayed on the Object Properties form.

2. Click the line that joins the two columns.

   Both fields are highlighted.

3. From the Join menu, select Types, and then select an appropriate join type.

   Simple is the default join type.

4. From the Join menu, select Operators, and then select an appropriate operator.

   Equal is the default join operator.

5. To delete a join, click the line that connects the two fields, and then select Delete from the Join menu.

   You can also right-click the join and select Delete from the pop-up menu.