Good day everybody!
I'm currently desperately trying to link three tables together so I can filter everything.
I following three tables:
tblEmployees
<tbody>
</tbody>
tblPlan
<tbody>
</tbody>
tblQualification
<tbody>
</tbody>
Both tblQualification and tblPlan are connected to tblEmployees via the ID.
Now I would like to investigate
How many employees I have per week or per day, who have the qualification "Mount" and are not registered as "ill".
Unfortunately, I always get the error message that there is no relationship. Probably because they are different dimensions, right?
Best Regards
I'm currently desperately trying to link three tables together so I can filter everything.
I following three tables:
tblEmployees
ID | Name |
1 | Kevin |
2 | Arnold |
<tbody>
</tbody>
tblPlan
Date | ID | Action |
01.01.2019 | 1 | A |
02.01.2019 | 1 | A |
03.01.2019 | 1 | Ill |
<tbody>
</tbody>
tblQualification
ID | Qualification |
1 | Mount |
1 | Drill |
2 | Package |
<tbody>
</tbody>
Both tblQualification and tblPlan are connected to tblEmployees via the ID.
Now I would like to investigate
How many employees I have per week or per day, who have the qualification "Mount" and are not registered as "ill".
Unfortunately, I always get the error message that there is no relationship. Probably because they are different dimensions, right?
Best Regards