I am starting over from scratch on a DB. I would like some input based on my proposed diagram and table structure of the DB.
This database needs to:
Record the Inspection results on a variety of different precision instrument measurement tools and send that data to the respective tables of each instrument and then present:
1) A minimum measurement allowance and a maximum measurement allowance for each instrument checked.
2) Show a Range of those measurements taken.
3) Present the Standard Deviation of the measurements taken.
4) Present an average of the measurements taken.
5) Present an Accuracy Rating of the measurements taken.
6) Present a Repeatability Rating confidence factor.
I next will need to develop Forms that can handle new data input and sub forms that can present the info from prior inspections and present that info in the sub form that would be represented by the numbers 1 thru 7 for each instrument type.
What I would like is for someone to review my table structure and table relationships to see if I am making a good start with my design for this database. I have nothing else developed at this point so lots of changes can be made.