Hi All, Thanks for all your help i have managed to do now the incrementing in the table as well as decrementing it.
Regards, Amey On 12/30/08, ccrashh <ccra...@gmail.com> wrote: > Why would there be a perfomance impact? How are you adding this new > record? You already know that the highest value is 5, so when you add > a new record (in your example called Test6) that the new Order ID > would be the current max order id + 1. So when you do a Push Fields > to create a new record, you push 6 to the order id. > > I really am curious as to how adding a new record is causing you to > have performance issues. > > Steve > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"