I have 2 tables
table a col name
table b col name
I have made the primary key of table a col name
and the foreign key = table b col na me and i set the relationship as cascade on update but i keep getiing this error
The UPDATE statement conflicted with the REFERENCE constraint "FK_T_b_T_a". The conflict occurred in database "test", table "b", column 'Name'. When I try to do the following update in table a
update a
Set name = 2
where name = 1
I want it to update b col name
Please any help would be appreciated