So you need a structure that sets up the inspection criteria for each part. Then need structure that reports the inspection results for each serial number. Again, I have parallels in my db. I have a 'Specifications' table. Sample (soil, aggregate, asphalt, concrete, etc) is received. Sample is logged in and coded for material type, project, specifications set, etc. Technician performs tests and enters data and report printed.