Select Tables to Join

The first step to combining multiple tables is to list the tables you want. Click the Tables tab:

To	Do this
Add a table by its description	Click on the Visual Assist in the Table column. From the resulting form, type the table description in the Description field.
Add a table by its object name	Directly type in the table name in the Table column.

Note: in EnterpriseOne, you can only join up to 3 tables if you use a one-to-many (OUTER) join. If you only use one-to-one (SIMPLE) joins, then you may only add up to 5 tables.