I've been using MS Access 2007 for a few years now, and I'm getting pretty good at simple relationships and forms and whatnot. But I'm having trouble with a project at work and I could use help. I'm not sure if it's a simple solution kind of problem or if it'll require a little VBA to complete or what.
I am creating a DB to track training attendance for the staff at my company. There's about 100 employees in the division I'm responsible for, and there will be anywhere from 5-75 people attending a training session. I have created a many-to-many relationship between the employee's table and the trainings table using a junction table that pulls the EmployeeID and the TrainingID from their respective tables.
I am able to add people to a training manually by opening the junction table and adding employee 1, 2, 7, 14, 15, etc. to training 7 (random numbers as examples...). I've got a form created for the Employees with a subform pulling from a query that displays that employee's attendance. What I DON'T have is a cleaner data-entry system for when I add a new training and add employee's to that training. I want my training form to have some sort of simple dummy-proof way to add people. It seems like I need some sort of continuous datasheet with dropdowns from which I can pull up an employee and add them to the training.
It seems like it should be doable and simple. But I'm having the hardest time coming up with a way to do it. Anyone confident they could help me? I'll pay you in Dastrn FunBucks.
I am creating a DB to track training attendance for the staff at my company. There's about 100 employees in the division I'm responsible for, and there will be anywhere from 5-75 people attending a training session. I have created a many-to-many relationship between the employee's table and the trainings table using a junction table that pulls the EmployeeID and the TrainingID from their respective tables.
I am able to add people to a training manually by opening the junction table and adding employee 1, 2, 7, 14, 15, etc. to training 7 (random numbers as examples...). I've got a form created for the Employees with a subform pulling from a query that displays that employee's attendance. What I DON'T have is a cleaner data-entry system for when I add a new training and add employee's to that training. I want my training form to have some sort of simple dummy-proof way to add people. It seems like I need some sort of continuous datasheet with dropdowns from which I can pull up an employee and add them to the training.
It seems like it should be doable and simple. But I'm having the hardest time coming up with a way to do it. Anyone confident they could help me? I'll pay you in Dastrn FunBucks.