I am having doubts about the table relationship in this database. Here are my observations / concerns:
The table: “tblToolNames” will have a list of instrument names such as “6” Digital Caliper” or maybe Digital Potentiometer there will be maybe 50 of each such instruments and each of these instruments will have multiple calibration checks performed on them during the year maybe 4 such checks.
Table “tblTools” will have dropdown list of the various different tool types in our inventory.
Once the checks are preformed I need to be able to view them in a form to see the effect of all four or more of the various checks that will be preformed.
Are the connections via the “tblToolNames” PK , to “tblTools” FK to the tblInspections” FK and the other 4 tables “Inspection_FK’s correct or should the connections be:
Via “tblToolNames” PK to “tblTools” FK to “tblInspections” FK and then to the other tables from “tblInspections” PK to the other 4 tables “MoisturePK”, “DimensionPK”, “TemperaturePK” and “DeflectionPK” ???
I am not sure of either these and would like some feed back as I going to spend a lot of time in development I want to be sure on this before I start