>I have table that has relation to itself. I have related field Field1 to field Field2 and set referential integrity for update to be Cascade (Delete - Restrict, Insert - Ignore). When I change value of Field1 it doesn't want to update Field2 with new value, it says that trigger failed.
>
>Why is that happening? Any solution?
Boban,
Once a Trigger routine is entered for a table, no modifications are allowed on that table
It is ok to have a cascade Table1 >> Table2, but not Table1 >> Table1
Gregory