Route number

[ApplePirate]

Does anyone one know of a way to insert a record into a table and then assign it a delivery route number, im building a database for a friend which will manage his milk deleivery route, i need to insert a customer in the delivery route and then reassign a delivery route number to all the remaining customers e.g
mr smith del no. 1
mr jones del no. 2

insert mrs smith into del no. 2
then mr jones decomes del no.3 Never ever, bloody anything, ever

 

[MichaelRed]

What you are discussing is a linked list type of operation. I posted an outline and some sample code for the initial parts of such a process a while back. You could (probably) find them using advanced search key word "linked List" as exact phrase. You would need to change the defauly (7 day) interval to 'forever' (AnyDate). This will return ~~ 20 threads, one of which I posted the couple of routine in. Others discuss the use of collections and UDTs to accomplish the similar process.


MichaelRed
m.red@att.net

Searching for employment in all the wrong places