dawsonrhodes
Member
- Local time
- Yesterday, 22:01
- Joined
- Mar 8, 2020
- Messages
- 85
Hello all,
I have been building an employee database, it has gone amazingly, just ran into something I wouldn't know how to sort out.
Basically, when we have a new training requirement come out we need to track completion. The way I currently do that is adding it in through the "Add New Training" form that I have attached as a png. But that then requires me to go into each person "profile" and create a new training log for each person and then mark it as completed.
The layout is as follows:
tblEmployees (master for all employee data)
What I am trying to do now is make it so that when I add a new training module I can select a box that will automatically make an entry in the query for each "person/id" that I can later go and just edit rather than having to manually add it with dropdowns.
Thanks all!
I have been building an employee database, it has gone amazingly, just ran into something I wouldn't know how to sort out.
Basically, when we have a new training requirement come out we need to track completion. The way I currently do that is adding it in through the "Add New Training" form that I have attached as a png. But that then requires me to go into each person "profile" and create a new training log for each person and then mark it as completed.
The layout is as follows:
tblEmployees (master for all employee data)
- ID (autonumber)
- EmployeeID (the number I designate them)
- Name and so on
- TrainingID
- Employee (so their auto ID in the tblEmployees table)
- NameofTraining
- Category
- and so on
What I am trying to do now is make it so that when I add a new training module I can select a box that will automatically make an entry in the query for each "person/id" that I can later go and just edit rather than having to manually add it with dropdowns.
Thanks all!