G
gst
I have a list of work orders in a database that I would like to assign a
priority number. This will be the order in which the work orders will be
worked. As new work orders are created the priority for the work orders may
be reassigned. If I have a list of work orders and they are numbered from 1
to 100, when the next work order comes in, I may assign that work order a
priority of 10. I would like to have the rest of the work orders to
automatically be reassigned priority numbers 11 through 101.
Any ideas?
priority number. This will be the order in which the work orders will be
worked. As new work orders are created the priority for the work orders may
be reassigned. If I have a list of work orders and they are numbered from 1
to 100, when the next work order comes in, I may assign that work order a
priority of 10. I would like to have the rest of the work orders to
automatically be reassigned priority numbers 11 through 101.
Any ideas?