Back | Forward

A report lists departments and shows the account ID for each department. The account name should also be on the report.

Solution:

Select the Departments table (DPT_MAIN) and the Accounts table (ACT_MAIN)

Connection required:

FROM the Departments table TO the Accounts table, through the Account ID field

Required restriction:

ACT_MAIN.ACCT_acct_code = DPT_MAIN.ACCT_acct_code