I've got a query subject that lists personnel names and their ID numbers.
Personnel
Personnel ID
Personnel Name
I've also got query subject that has multiple types of personnel for approving purchases:
Approval Process
Approver 1 ID
Approver 2 ID
Approver 3 ID
Currently, the approver ID = Personnel ID, however when I try to join them together, I always create a cross join. The overall goal is to replace the Approver ID with Personnel Name.
There is a currently a report that lists the various approvers for a particular purchase but it only shows the approver ID, when I actually need the approvers name.
Any ideas?
I presume you need each Approver's name from the Personel table ? if so, do this:
1> Create 2 alias shortcuts of Approver Query subject.
2> Join the original Approver Query subject to personnel with Approver 1 ID= Peronnel ID
3> Join the 1st shortcut to Personnel with Approver 2 ID= Peronnel ID
4> Join the 2nd shortcut to Personnel with Approver 3 ID= Peronnel ID
5> Create a Model Query subject and include Approver 1 ID, Peronnel Name (Name if appropirately to reflect name of Aprrover1 ID, Approver 2 ID, Peronnel Name (Name if appropirately to reflect name of Aprrover2 ID, Approver 3 ID, Peronnel Name (Name if appropirately to reflect name of Aprrover3 ID
Hope it helps
Thanks Steve, that helps a lot. I didn't understand at first but after playing around with it for a bit, I ended up with what you advised and THEN I understood your post. ;D