Rotating Information in a Form

  • Thread starter Thread starter Clint Williams
  • Start date Start date
C

Clint Williams

I need to create a form for assigning work to several
employees on a rotating basis. The rotation must be in a
particular order, and must repeat when the last person in
the list has been utilized. I have several thoughts, but
all involve a large amount of work, and I am not trying to
re-invent the wheel. Any thoughts or assistance.
 
You keep a sorted list (table) with a surrogate autonumber and a foriegh key
(worker)
Another table keeps the id of the last one assigned.
Your code positions using recordset find to the last id, if this is end of
file you move first and assign

An unsorted list can use absolute position and move (rows)
peter walker
 
Back
Top