How to Change Table Relationships

If you create a report that returns data from multiple tables and find that the data you want isn't being returned, you may need to change the relationships of the report’s tables.

You can change the order of the tables, the join types connecting the tables, and the specific fields that are linked together in the tables, as long as the fields are linked in the database. You can also delete tables that are no longer needed in the report.