maybe this totally misses the mark but maybe
tblDepts |
|
tblCust |
|
tblDefects |
|
tblComment |
DeptID |
|
CustID |
|
DefectID |
|
CmntID |
DeptName |
|
Lname |
|
DefectDesc |
|
CustID_fk |
|
|
Fname |
|
|
|
CustCmnt |
then 1 table to join
tblCmtData |
DataID |
CmntID_fk |
DeptID_fk |
DefectID_fk |
where join table would have 5 records with ID. Data might then look something like
DataID
|
CmntID_fk |
DeptID_fk
|
DefectID_fk
|
1 |
2 |
1 |
2 |
2 |
2 |
1 |
3 |
3 |
2 |
3 |
1 |
4 |
2 |
4 |
4 |
which enables any department to have more than one defect type. Basing that on only tracking 4 defect types as stated, otherwise, maybe not.
Last edited by Micron; 07-09-2019 at 06:38 PM.
Reason: added comment
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.