Automatically assign task in form field based on date and employee load

[kirairo]

I want to accomplish the following but have no clue how:

Tables:
- Employees_table
- Tasks_table



Logic:
- Each employee can handle 4 tasks in any given day
- I want to populate the Tasks_table using Forms, one field would be for "assigned employee"... however, I want this to be automatically filled for each new task based on the date entered so it will cycle through employees and not repeat any name more than 4 times in any given date


Hope there is a way to implement this kind of form design. Thanks in advance!

[ssanfu]

How many total tasks are there?

If tblEmployees are for the employees and tblTasks are for the list of tasks then you will need another table for employee and tasks (jnctEmployeeTasks).

What fields are in tblEmployees?
What fields are in tblTasks?
Would you list a few tasks?
Or you could post the dB...


How would you manually assign tasks to an employee?