Houssam,
>I have a table which is referencing itself. I need to know how I can control the order of update so parent records get updated first. Bearing in mind that child records may have been created first (by assigning the parent code later after the parent has been created)
Wouldn't the child records already have the parent code at the point where you save the DataSet?
Regards,
Kevin McNeish
Eight-Time .NET MVP
VFP and iOS Author, Speaker & Trainer
Oak Leaf Enterprises, Inc.
Chief Architect, MM Framework
http://www.oakleafsd.com