Hi!
I'm completely new at Access and I only need this one thing done for now. After trying to figure it out for the past five hours, I'm ready to explode so I need help.
Basically, at my work, there is a set list of places that require an employee, but each employee knows some of the places only, and they're not always the same employees every day.
What I'm trying to do to ease allocating them to the right place is having some kind of form (anything that will be easy for my colleagues to just click on once it's all set up) linked to a list of what each employee knows.
I've managed to create a table, with ID being that random number assigned, then an employee name as simply a text that you input, and then as an example, Place 1, Place 2, Place 3, and those are ticking a box if they are trained on it.
Imagine I've got 100 employees on there in total, and 20 places to fill every day, how can the person allocating people on the Tuesday select multiple employees on a form (the ones coming that day), press a button, and voila, you would get the same table as the full one, but with just them and all the Place columns displayed (so they can see, only one person knows place 3, four people know place 6, etc...).
Also, if you wanted to switch up an employee for another, and wanted to see what they knew, would you have to run the whole query again and reselect everyone, or is there some way to hide/show different records?
Thanks a lot,
Lea