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"