I need to automate the assignment of tasks to employees. There are three employees to divide the work by. The data I'm looking at right now shows 13 unassigned items, but I'm sure that can vary. My user said I don't have to worry about assigning items to people who have far less cases than others. All she wants is to evenly divide the open items (in this case 13) among the employees. I have the open items in a temp table which will be appended to the Master table after I've assigned the employees. The employees have specialized skills and are selected by that skill from a query, so I'd be using that queryset to pull the employee number and plug it into the AssignedTo field in the temp table.
Thanks for any help!!