Here is the just of what my database does. I have a room with a set of equipment which I am tracking the availability of. This equipment goes down for preventive maintnenace and sometimes failures.
When a user wants to input a status of a tool an append query is activated which allows them to enter the name of the tool and the desired status of the equipment either Down, Umip, Umcomp and UP.
In order for me to track the uptime of these tools I need each status to be entered successfuly. I consider a full transaction to be Down, Umip, Umcomp and UP for each time a tool goes down. The problem I have is sometimes my crew accidently skips a step.
Example, A tool was put Down for an error, my technician would then place the tool in Umip (maintenance in progress) status. Lets say he fixed the error but instead of placeing the tool in Umcomp (maintenance completed) he when directly to UP because he wasn't paying attention.
I would like to find a way to make sure that no steps are missed, essentially ensuring that each transaction is entered in succession from down - up and possibly notify the user with a error msg.
Sorry for the confusion I can attach my database if it would help.