0

I will try to make this as simple as possible. Any help would be greatly
appreciated. I have 3 tables like below.

tblEmployees
-----------------------------------------
EID | Name |
1, John
2, Bob
3, Steve
4, Brian
5, Joel
6, Lance
-----------------------------------------

tblTraining
-----------------------------------------
EID | JOB |
3, 1
4, 1
5, 3
3, 3
4, 2
-----------------------------------------

tblJobFunctions
-----------------------------------------
JID | Job_Name |
1, Picking
2, Packing
3, Shipping
-----------------------------------------

I was looking to produce results like this. Basically it will list ALL employees, and provide me with a scorecard type of training conducted. IS THIS POSSIBLE?

NAME, PICKING, PACKING, SHIPPING
John,No, No, No
Bob,No, No, No
Steve,Yes, No, Yes
Brian,Yes, Yes, No
Joel,No, No, Yes
Lance,No, No, No

2
Contributors
1
Reply
2
Views
9 Years
Discussion Span
Last Post by ProfessorPC
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.