Selecting Tables for Business Views

Access the JD Edwards Business View Design Aid form.

1. On the Design Tools tab, click Start the Business View Design Aid.

2. On the Available Tables form, use the query by example (QBE) line to search for an appropriate table.

3. Select one or more tables, and drag them to the Table Joins form.

   This form is called Table Joins regardless of whether you are joining multiple tables or working on a single table.

4. If more than one table is selected, double-click the title bar of the appropriate table to designate it as the primary table.

   If the business view contains multiple tables, the system automatically designates the first table that is added to the Table Joins form as the primary table. A crown icon appears in the upper-left corner of the primary table. If a business view contains only one table, that table is the primary table by default.

   Note: To delete a table from a business view, select the table and select Delete from the Table menu. You can also right-click the table and select Delete from the pop-up menu.