Hi,
I have a common tasks table m-t-m:
tblPart: PartID, PartNumber, PartDescription
tblTest: TestID, TestNumber, TestTask, TestMinReq, TestMaxReq
tblPartTest: PTID, PartIDFK, TestIDFK
These tables have pre-defined part numbers, test tasks, requirements. e.g.
PartNumber: 111456, 111234, 23156A...