I am new to Access and have been tasked with designing a shopfloor facing data entry form that does the following:
I have 25 different machines, the most tools any machine can hold is 40 Tools; but the Tool Life for any given tool might be different, in some cases they are the same. I am trying design it as such that I don’t have to have laminated card broken down by machine with Tool life’s listed and in the event of any improvements made the projected tool life in the MachineTbl can be increased.
The adaptability needs to be:
1. add additional machines in the event more machines come online or more are purchased.
2. Tool Numbers might be moved around, rare but possible
3. Expected Tool Life values might increase or decrease based on real world results.
At the moment I am trying to just get all my inputs structured so next:
1. I can make a Data entry form that has the Product Line, Machine Number, Tool Number as selectable Combo Boxes.
2. Based on what Machine Number and Tool Number is selected a box on the form would have the "Expected Tool Life" populated automatically.
3. The user would then input what the life was if changed early and the reason for the change
4. A "submit" button would be on the form to then populate the usage data.
5. Which is exported via Excel to be analyzed and graph usage on monthly basis.