Open topic with navigation

> The structure of a report / Join tables / Using related tables in the Join Editor

This feature is only available for:
Sage 200.

Using related tables in the Join Editor

If your Sage software supports related tables, the relationships between the tables are created automatically. When you add a table, you can choose to link to its related tables.

Add joins for related tables

Add a new table
  1. Choose Report > Joins.
  2. Find the table you want in the Toolbox pane and drag it to the Join Editor's centre pane.
  3. To join a table to its related tables, click Yes when prompted to add the links to the listed tables. The tables and links are added to the report.
Add a join to an existing table
  1. Select the table you want to add a join to.
  2. Right-click and select Add related table.
  3. Select the relevant table from the list. The table and the link are added to the report.

Go to top