tblStaffProcedures which has staffprocedureID(pk) procedureDate procedureName staffName TimeTaken
Close but not quite. I'm assuming that where you put "procedureName" in the junction table that you mean to repeat the actual values from the parent tables. So more like
tblStaffProcedures with staffprocedureID(pk) procedureDate, procedureNameFK, staffNameFK, TimeTaken; where the Fk fields contain the PK values from the related tables. If staff and procedure looks like
staffID |
Lname |
|
procedureID |
ProcedureName |
1 |
Smith |
|
1 |
A |
2 |
Brown |
|
2 |
B |
3 |
Jones |
|
3 |
C |
then the junction looks like
tblStaffProcedure |
|
|
staffprocedureID |
ProcIDfk |
staffName |
1 |
1 |
2 |
2 |
2 |
2 |
3 |
3 |
2 |
This shows that BROWN has been assigned procedures 1, 2 and 3. I left the other fields out. This method has at least one advantage in that if you change a procedure name, it never matters because the linking fields are PK/FK so the new proc name is what's shown on your form.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.