You can also add supplementary tables to the report if you need to pull information from fields not available in the main table. Click the + in the Join Info column to choose from a list of tables related to the main table.
The lower dropdown box contains the different tables that have a relationship to the main table. Select the table to which you’d like to join the main table. The box just above it allows you to choose the join type.
There are four types of joins available when adding tables to a report.
NOTE: It is always better to choose the correct main table and add additional tables than try to compensate for choosing the wrong table by adding tables and modifying the join.
Any join will show beneath the main table. Unlike the main table, joins can be added at any time and can also be removed from the report if you either chose the wrong table or no longer need its information. You can add multiple joined tables. Tables can be joined directly to the main table or joined to another table, which is joined to the main table. Click the + for the table to which you want to join another. In the example below, the PM table is joined to the COMPINFO table (Assets), which is joined to the WORK table (Work Orders), which is the main table. This is indicated by the blue arrows.
Each table is displayed in a different color and the fields on the right side of this screen are displayed in the same color as their corresponding table. This makes it easier to see from which table a particular field was taken. You can add fields from these tables, by clicking on the folder next to the table, just like adding fields from the main table.
You can change the join type by clicking on the pencil icon for that table, or remove the table by clicking the trashcan.