Cascading Changes in Parent to Child Rows

Question

I have a parent table which I require the ability to change fields in.  I'm using the dataTable or/and DataSet to Update it and always recieve in error stating that it can't be changed due to having related child tables.

I've never worked with child tables but have read that there exists a means to have the changes in the primary table/row be cascaded down to the all child rows that are related.  I just can't seem to find an article relating to this exact concept.  

Any help on this matter is greatly appreciated!  Thanks and havve a great day.

piBoss

---

Glenn T. Kitchen VB.NET Forums

Answer 1

is your problem related to WCF Data Service ? for me it look like ADO.Net problem?

Answer 2

No, it isn't.  I'm simply using ab Access database, and a DataAdpater to work with the database.

---

Glenn T. Kitchen VB.NET Forums

Answer 3

Requesting Moderator to move it to appropriate forum 

Answer 4

Hi Glenn,

Since this is a old thread, I wonder if you solved the issue yet?

If you haven't, I suggest you read the links below.

http://msdn.microsoft.com/en-us/library/st1t2c35.aspx

http://support.microsoft.com/kb/310350

Best Regards,

---

Bob Wu [MSFT]
MSDN Community Support | Feedback to us