[AccessD] Insert record into fake group

Gustav Brock gustav at cactus.dk
Thu May 8 07:06:41 CDT 2003


Hi Ervin

>> Why not simply update the SchoolOrder:
>>
>>   1            1
>>   4            2
>>   2            3
>>   3            4
>>
> I dont know what do you mean by updating SchoolOrder because the user have
> to insert the SchoolOrder, he have to determine the "group" and the order
> within the group too. But John suggested inserting a leading zeroes into the
> field SchoolOrder(and expanding the field into two parts: group and order),
> and that works pretty well.

That's very simple. When the user decides an order number for a new
school, update the schools with that or a higher order by one and
add the new school with the decided order.

/gustav



More information about the AccessD mailing list