Crystal Linking Challenge 1

[crooksb]

Can I do this. Say I had 2 tables, a Bosses table and an Employee Table.
The Bosses table has an Id field, Name Field, and Manager Type field
The employee table has, among other things, 3 fields relating to the bosses table - SupervisorId, ManagerId and ReportsToId - all of these ID's refer to an individual record in the bosses table. Is it possible to link the two tables together (3 links from employees table to one ID field in the Bosses table? For example, the employees file has a SupervisorId of 10, a ManagerId of 4 and a ReportsToId of 32 referring to 3 separate records in the Bosses table.

 

[lbass]

I think you would need to add the Employee table three times and then use left joins from the bosses table to each of the employee tables, linking {bosses.managertype} to one type of field in each of the employee tables.

-LB