Re: maintaining delivery order in a table

2003-03-24 Thread Trevor Smith
On Mon, 24 Mar 2003 15:17:09 -0500, Keith C. Ivey wrote: >You should definitely keep IDs and order as separate columns, since >you don't want to have to change IDs if the order changes. You might >consider representing the order with a nonconsecutive series of >integers -- for example, leave g

RE: maintaining delivery order in a table

2003-03-24 Thread Don Read
On 24-Mar-2003 Trevor Smith wrote: > I want to create a table of customers on a delivery route. I want to > include the order of delivery in the table. Creating a column with a > sequential id # would be very cumbersome because in the future some new > customers may subscribe -- and these new cust

Re: maintaining delivery order in a table

2003-03-24 Thread Keith C. Ivey
On 24 Mar 2003 at 13:08, Trevor Smith wrote: > I want to create a table of customers on a delivery route. I want to > include the order of delivery in the table. Creating a column with a > sequential id # would be very cumbersome because in the future some new > customers may subscribe -- and thes