How to connect two tables more than once?

[#1]

Basically, I have one table called Sale with CashierID and ManagerID. Both fields relate back to EmployeeID in the employee table. I would like for their full names to pop up instead of their employee IDs, but I'm having trouble making this happen in Qlikview. I can get one name to show using (FIRSTNAME||' '||LASTNAME) AS CashierName, but I can't seem to get both to pull the correct name.

Thanks!

[maxgro]

You can load the employee table twice

Rename the EmployeeID field as CashierID for one employees table

and ManagerID for the other.

Sale

     CashierID

     ManagerID

     ......

EmpCashier

     CashierID

     CashierName

     .....

EmpManager

     ManagerID

     ManagerName

     .....