Multiple EmployeeID fields in a table
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
|