I believe my tblECR Needs to be broken apart to achieve 1 EmployeeID field
per table, but I'm not too sure on the best approach for this. This is an
engineering ECR tracking database where each record shows multiple tasks
performed by multiple employees. Can someone point me toward north on this?
Thanks!

Tables:
tblCustomers
CustomerID
CustomerName

tblECR
ECRNumber
PartNumber
CustomerID
DateInitiated
|-------------OriginatedBy
| ChangeSummary
| JobNumber
|-------------LoggedBy
| ImportanceID
|-------------ReviewedBy
| DateReviewed
| DateReq
| VantageChecked
| Attachments
| ReqDwg
|-------------DwgRevBy
| DwgRevDate
| ReqMaterials
|-------------MaterialsRevBy
| MaterialsRevDate
| ReqCutlist
|-------------CutlistRevBy
| CutlistRevDate
| ReqProgram
|-------------ProgramRevBy
| ProgramRevDate
| EngNotes
|
| tblEmployees
|-------------EmployeeID
FirstName
LastName

tblImportance
ImportanceID
Importance

tblParts
PartNumber
PartDesc