Automatic assignment of case to worker
We're designing a system in which a new case will be entered into the system, and the functionality we're looking for is automatic assignment to a worker, based on a rotating basis. I'm not even sure...
Forum Discussion
Are specific Cases established, or is that a free text entry field? If it's the former, it sounds like a related parent table with lookups brought into the child is in order here, so far...
The parent table would consist of records of Cases with an associated Worker for that Case. When a Case Details record is made in the related details table, a case is selected from a drop down list and the worker would be brought in as a lookup field.
Rotating the workers would be based on what? Dates of availability? How is rotation established?