Sorry to bother you guys but I have another questions related to DataSets.
I'm almost there now, so I dont expect to bug you much more ( Hopefully ).
I have Master / Details tables with cascading relationships between them.
When I Update the master using the DataAdapter we get a new ID for the new
master row and all the child row foreign keys are updated to the newly
aquired ID.
However, from an article below from bill vaughn, he suggests ( Unless I
have misunderstood ) that the child rows would be automatically inserted
into the SQL Database after the master row has been created and they get
their foreign keys.
http://msdn.microsoft.com/library/de...anidcrisis.asp
I am at a bit of a loss as to how this could be done with one insert command
( Not demonstrated in the article ). If you configure a second DataAdapter
for the Details table, this does not insert the rows after the initial
Master row creation.
I would appreciate some help as to where I may be going wrong ?
Thanks In Advance !
--
Best Regards
The Inimitable Mr Newbie º¿º