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
Tasks: Measure resistance, Measure Inductance, Workmanship-Check (Y/N)
Now I have a part number being built and tested. Operator needs to create a new record for the part being built with a host of sub-records associated with that part and place actual value measured.
tblTransaction: TransID, PartID, Operator, Date
tblMeasurement: MeasureID, TestID
tblTransacMeasure: TransID, MeasureID, ActualMeasurement
Question1: Is the above logic correct?
Question2: How do I create a form with this setup for the operator to pick a part number from dropdown and see all the tasks and where he can enter actual readings across from each task.
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
Tasks: Measure resistance, Measure Inductance, Workmanship-Check (Y/N)
Now I have a part number being built and tested. Operator needs to create a new record for the part being built with a host of sub-records associated with that part and place actual value measured.
tblTransaction: TransID, PartID, Operator, Date
tblMeasurement: MeasureID, TestID
tblTransacMeasure: TransID, MeasureID, ActualMeasurement
Question1: Is the above logic correct?
Question2: How do I create a form with this setup for the operator to pick a part number from dropdown and see all the tasks and where he can enter actual readings across from each task.