|
|
|
|
|
When you open this window, the report's main table will be the only table listed. The number 01 will appear to the left of the table name, denoting its status as the report's main table.
Click New to add another table to the report. The Related Tables window will open. This window contains a list of all tables that have a relationship with the main table already defined. An asterisk appearing next to the table name denotes a one-to-many relationship. Select the desired table and click OK. Each table that is added to the report and is directly linked to the main table will be listed below the main table in the Report Table Relationships window, with a single dash to the left of the table name.
To add a table that is linked to a table other than the main table, select the secondary table's name from the Report Table Relationships window and click New. Select the name of the table to be added and click OK. This table will appear in the Report Table Relationships window below the table that it is linked to, and will have two dashes to the left of its name.