Automatically updating matrix

[reuip]

Hello

I have a question about something I've been asked to do for my company.



We have 10 managers that on a regular basis are asked to sit in on 5 work sessions with employees. Managers are randomly assigned to give employees feedback based on this observation, with employees getting a max of 5 sets of feedback.

I am wondering if there is a way to automate this process with access. For instance, can I input all of the employees into one table, all managers into another, set a variety of limitations or rules (e.g. no manager gives the same employee feedback more than once) and have access automatically populate a matrix with employees and managers paired up across these sessions?

Is this possible?

[kimmer]

You will have to investigate to see if indeed it will work for this, but I would have a look at Excel's Solver tool.

[reuip]

Thanks for the tip. Tried that out. I dont believe it will work for the size group I have. It also appears to have some trouble just generating 1s and 0s for who should or should not be put into groups together.

Any thoughts on whether this is possible to program into Access?