Workflow - Work Distribution

  • Thread starter Thread starter Rick Neal
  • Start date Start date
R

Rick Neal

I am tring to put together a query or series of queries
(my VBA expeirience is very low) that will distribute
work assignments by creating child records in another
table based on the two parent tables
Parents: -Work (records of customer transactions)
- Employees (records of available employees that perform
the necessary job function.

I must use logic to match employees to transaction type
based on.
A) what types of transactions each employee can process
B) The amount of volume each employee can handle [(based
on employee level) taking into consideration that ALL
transaction types will have to be tracked together]
C) making sure that there is even distribution of "work"
across all employees regardless of transaction type.
 
I should perhaps mention that my question is what is the
best way to go about doing this so I can still update
multiple records (100's)at one time.
 
Back
Top