Houssam,
>Yes, but what is exactly the order of update? If its: the first record updated gets first to the database, then the child record will get there first and we will get an error. Since at this point, the parent does not yet exist, bits its already referenced by the child record.
If you really need to ensure parents are saved first, then children second, you'll need to put them in separate DataTables, or you could even put them in separate DataSets. That way you can always save parent records first, then children second.
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