Re-ordering a queue

[Watkin]

Hi everyone!!
Okay, so I'm developing a system where orders are taken in from clients, and then their orders are processed for production, based on the required delivery date (i.e not first in, first served, but production based on when the product is needed). Now, I see that for a reasonable amount of the time, first in first served will be fine, so adding the new order to the end of the list will be ok, however, there will be times when the order will need to be slotted in between some orders. At the moment I'm stuck for ideas on how to do this!!
Currently my forms are all unbound, I prefer to do inserts, etc, myself...
Can anyone explain how to do this to me?!?!
Thanks in advance,
Watkin.

 

[Watkin]

I forgot to add, that the only information in the "Queue" table is the info that is required (customer code, product code, etc, etc), and there is an index for the numbering, but that is not currently an autonumber...I've only designed this on paper, so if you can rearrange things to make it easier, then feel free to do so, because I haven't started coding yet (not sure atm where to start!!)