From some discussion in another thread (http://www.access-programmers.co.uk/forums/showthread.php?t=266376) it was suggested that I post a question here regarding table design. Attached is a copy of my DB. I'll mention right now that this is half-completed (if that).
The short explanation of what I'm doing:
I need to create an SPC program. The goal is to have an operator on the floor enter their factory order and other info. The system will then look up the SPC limits for that given set of variables. The SPC limits will be maintained by engineering.
The operator will then enter X number of measurements (part of the spec table) each Y time (not part of the spec table yet, not sure if it is going to be). The system needs to take the operator input, check it against SPC rules (which can be activated or deactivated as needed by spec) and tell the operator if there is a failure. It also needs to display a chart with the spec limits, control limits, and any failures highlighted.
I think that pretty well sums it up. You can read the other thread for a description of the problem I'm having. I can provide more info if you have any questions.
The short explanation of what I'm doing:
I need to create an SPC program. The goal is to have an operator on the floor enter their factory order and other info. The system will then look up the SPC limits for that given set of variables. The SPC limits will be maintained by engineering.
The operator will then enter X number of measurements (part of the spec table) each Y time (not part of the spec table yet, not sure if it is going to be). The system needs to take the operator input, check it against SPC rules (which can be activated or deactivated as needed by spec) and tell the operator if there is a failure. It also needs to display a chart with the spec limits, control limits, and any failures highlighted.
I think that pretty well sums it up. You can read the other thread for a description of the problem I'm having. I can provide more info if you have any questions.