Change Table Joins and Linked Fields

You can edit your report’s data set to change the tables’ join types. In addition, if the tables can be linked by more than one field, you can select a new field to link to.

1. Click the Home tab.
2. Click Tables to open the Data Set window.
   When you open the Data Set window, you see the tables in your report and their relationships. When two tables are inner joined, two overlapping circles with their intersection highlighted display next to the secondary table. When two tables are outer joined, two overlapping circles with one circle highlighted display next to the secondary table.
3. Click the table that's joined to the primary table.
4. Enter field information.

   Data Set Window

   Field	Description
   Table	This field displays the database name of the table you have selected.
   Delete Table	Click this text to remove the table you have selected from the report. If the table acts as a parent to other tables in the report, the child tables are also removed. Columns aren’t automatically removed from the report when their associated tables are deleted. These need to be manually removed before the report can be saved.
   Alias	This field displays the alias name of the table you have selected. The alias allows you to add multiple instances of the same database table to the same report. For example, the first instance of the contacts table could have an alias of “contacts,” and the second instance could have an alias of “contacts2” to distinguish it from the first instance.
   Join To	This field displays the table the selected table is joined to.
   Join Condition	If the table join can link to more than one field in the joined tables, click this drop-down menu to select the fields you want to use to join the tables.
   Join Type	Select the Inner option to use an inner join or the Outer option to use an outer join. To change the join type, you can also right-click the joined table in the data set tree and select Toggle Join Type.
   Join Filters	You can add, delete, or view join filters in this section. Join filters apply only to outer joins and aren't available if the Inner join type option is selected.