How to cascade child and parent in SQL Server 2008 R2 -


i set relationship b/w 2 column (primary key , foreign key on unique id)

i able 2 change id in parent form , effect on child table problems can change primary key not column never change , cause problem user , report functions. created relation sql server 2008 r2's diagram , use dataset.

i tried use delete cascade , works fine , deletes whole child in forms on update have problem.

is there way update child columns parent table?

thanks.


Comments

Popular posts from this blog

Change the color of an oval at click in Java AWT -

c# - Unity IoC Lifetime per HttpRequest for UserStore -

I am trying to solve the error message 'incompatible ranks 0 and 1 in assignment' in a fortran 95 program. -