Hi
Firstly, some background. I am building a database, part of which will be used to log when employees set off stability alarms when driving machinery. The first time an employee sets an alarm off, they are put on to stage 1. The next time stage 2 and finally stage 3, which becomes a disciplinary matter. Each stage lasts for 3 months, then they go back to zero. I have created a form to select an employee and enter that they have set off an alarm.
My question is, can Access work out what stage the employee is on when a new entry is made? The employee details are in one table, and the details of when they set an alarm off are in a separate table linked by employee number. So I would need access to look at what stage they were last on, if any, work out if it was within the last 3 months and then enter the new stage into the stability table.
I hope that all makes sense. Any help would be greatly appreciated.
Firstly, some background. I am building a database, part of which will be used to log when employees set off stability alarms when driving machinery. The first time an employee sets an alarm off, they are put on to stage 1. The next time stage 2 and finally stage 3, which becomes a disciplinary matter. Each stage lasts for 3 months, then they go back to zero. I have created a form to select an employee and enter that they have set off an alarm.
My question is, can Access work out what stage the employee is on when a new entry is made? The employee details are in one table, and the details of when they set an alarm off are in a separate table linked by employee number. So I would need access to look at what stage they were last on, if any, work out if it was within the last 3 months and then enter the new stage into the stability table.
I hope that all makes sense. Any help would be greatly appreciated.