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