Hello everybody,
I have two tables in the following format:
tblSkills:
<tbody>
</tbody>
tblPlanning:
<tbody>
</tbody>
It can be seen that the first table is partly a cross table.
The other table is a classic list.
Both can be linked using a calendar table and a master data list (name, ID).
Now I have to somehow connect the abilities with each other, in order to be able to carry out appropriate evaluations with the help of a pivot table.
Does anyone of you have any idea which structure would be best for this?
Best regards
I have two tables in the following format:
tblSkills:
Name | ID | Function | Assembly | Drilling | Polishing | Package |
Jeremy | 001 | Operator | 1 | 1 | 0 | 0 |
Rodger | 002 | Operator | 1 | 0 | 0 | 0 |
<tbody>
</tbody>
tblPlanning:
Date | ID | State |
01.01.2019 | 001 | Assembly |
01.01.2019 | 001 | Drilling |
<tbody>
</tbody>
It can be seen that the first table is partly a cross table.
The other table is a classic list.
Both can be linked using a calendar table and a master data list (name, ID).
Now I have to somehow connect the abilities with each other, in order to be able to carry out appropriate evaluations with the help of a pivot table.
Does anyone of you have any idea which structure would be best for this?
Best regards