[AccessD] Insert record into fake group

"I'm one but I don't beat"

...just don't mention Novell anywhere within a parsec of gustav! :))))))

William Hindman
----- Original Message ----- 
From: "Gustav Brock" <gustav at cactus.dk>
To: <accessd at databaseadvisors.com>
Sent: Thursday, May 08, 2003 8:55 AM
Subject: Re: [AccessD] Insert record into fake group


> Hi Ervin
>
> Before you'll get beaten by the normalization gurus of the list (I'm
> one but I don't beat) you should consider to split those sort orders
> out to separate (numeric) fields. In the long run I'm convinced it'll
> save you a lot of trouble.
>
> /gustav
>
>
> >> Why not simply update the SchoolOrder:
>
> > I think you were right that sometimes I have to update the field
> > SchoolOrder. If I use John's system(and I think I will) where the
> > SchoolOrder consist from 2 parts: "Group.OrderInGroup" everything is ok,
> > except when arise a new group which have to shift the existing groups or
> > orders...
>
> > I have to admit that part "Group" here means City, the part
"OrderInGroup"
> > is order within a group(within a city) and the field SchoolOrder is here
to
> > sort schools in order how will salesperson visit them.
> > E.g. when new first group arise then each Group have to be incremented.
The
> > same is for the part OrderInGroup: e.g. when arise new first in some
group
> > then the part OrderInGroup have to be incremented...
>
> > Thanks anyway, I'll try to make some update queries tomorrow.
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>