foreign key update in Tableadapter dataset

[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

 

[Sreekanth]

I figured. I had to edit the relation and select cascade options.