
Associating Number/Text Fields
I have a database with two tables. The first table has all employee names
and employee numbers. The second table has data that contains a "supervisor
number" field to show who authorized a transaction and "employee number"
field to show which employee performed the transaction, but no name field.
The second table is linked to the first by the employee number. We are
producing a daily report sorted by supervisor number that lists date,
employee name, number, and transactions, all authorized by that supervisor.
The employee name and number fields show data correctly in the details
section of the report, the supervisor number shows correctly in the group
header section, and it sorts correctly by supervisor, but I cannot link the
supervisor number back to the first table with employee names to show the
supervisor's name on the report (not just a supervisor number). When I add
the employee name field into the group header section to show a supervisor
name I get the first employee's name on the list from the details section.
There should be a way to bind the supervisor number back to the employee
name in the employee name/number table.