foreign key update in Tableadapter dataset

  • Thread starter Thread starter Sreekanth
  • Start date Start date
S

Sreekanth

I have a dataset with TableAdapter A and TableAdapter B. B has a
foreign key which refer backs to A.

I add a row to table A and then add several rows to Table B. I update
ID of table A of table B with newly added key of Table A (-1)

When I update table adapter A to the database, I get a new value for
ID from database.

But it is not automatically updating references made in Table B.
Shouldn't the new value of Table A automatically propogate to all the
rows in Table B? Or, do I need to update every row of table B with new
ID?

Thanks
 
Back
Top