Im new in MS SqlServer , im using version 7.
Its posible to have at the same time FK, and cascade update.
I have created a FK between a parent and a child table,
and i also created a triger update in the parent table in
order to transmit any update of the parent to the child.
But it doesnt work. My trigger only works when i disable
the option "Enable relationship for INSERT and UPDATE" of
the ralation(FK), But this can not be done, because it
allows the insertion of bad values (which doesnt exist in
the father) in the child.
Must I skip the use of FK, ant make it all by code
(triggers) perhaps?.
Any idea
Sorry for my English
Antonio
Its posible to have at the same time FK, and cascade update.
I have created a FK between a parent and a child table,
and i also created a triger update in the parent table in
order to transmit any update of the parent to the child.
But it doesnt work. My trigger only works when i disable
the option "Enable relationship for INSERT and UPDATE" of
the ralation(FK), But this can not be done, because it
allows the insertion of bad values (which doesnt exist in
the father) in the child.
Must I skip the use of FK, ant make it all by code
(triggers) perhaps?.
Any idea
Sorry for my English
Antonio