scripting a rotating "Up" sales board?

[manganese25]

I am trying to script a routine that will take a list of "available" salespeople and put them in order "on deck". When with a customer, I want to move the top person "on deck" to an "On the Floor" list. When the person is finished with a sales opportunity, I want to move his/her name to the bottom of the "on deck" list. If you are familiar with furniture sales, you know the routine! Sounds simple, but I've been racking my brain for well over 12 hours trying to figure this out.

I have a database of "Employees" and a database that acts as the interface for my "Up Board"

If anyone can help, please email me with any ideas.

Thanks!

[email protected]

[KentL]

You might be able to use a number field and a global. When someone comes back off the floor, set the global field to global +1 (so its a counter), then set the number field to the value of the global. You can then sort by the number field. When they go back on the floor, remove the number from the number field. Hope this makes sense...