Hello,
I have three tables (m-t-m):
-tblPart: PartID, PartNumber, PartDesc
-tblTest: TestID, TestName, PrameterNo, ParameterDesc, ParameterReqMin, ParameterReqMax, ParameterUnit
-tblPartTest: PartTestID, PartIDFK, TestIDFK, ActualReading
Question:
How do I setup:
-tblTest with different units (e.g ParameterDesc = Workmanship,
ParameterReqMin = blank, ParameterReqMax = Blank, ParameterUnit = Check(y/N)
-tblPartTest: ActualReading = Checkbox, or Number, LongInteger, % etc
I have three tables (m-t-m):
-tblPart: PartID, PartNumber, PartDesc
-tblTest: TestID, TestName, PrameterNo, ParameterDesc, ParameterReqMin, ParameterReqMax, ParameterUnit
-tblPartTest: PartTestID, PartIDFK, TestIDFK, ActualReading
Question:
How do I setup:
-tblTest with different units (e.g ParameterDesc = Workmanship,
ParameterReqMin = blank, ParameterReqMax = Blank, ParameterUnit = Check(y/N)
-tblPartTest: ActualReading = Checkbox, or Number, LongInteger, % etc