You could use a single SQL statement in an Active Link to update records to order_id -1, where the order_id > than that for the record just deleted. Just add an integer display only field 'zTmpCurOrderId' which is set to the order_id for the current record about to be deleted. Use this value in the SQL statement. The table refreshes correctly and the order_id's get updated as expected. Can send you the code off-line if it helps? I trust this is of some help. Kind regards Mike
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
