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
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
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