I want modify relation between tables, in the next way: i just wanna delete this relation. Why that: when i delete a record, i launch a trigger that updates all tables where this record is envolved, but i get the next message:
DELETE statement conflicted with COLUMN REFERENCE constraint 'FK_ResMetod_Pet'. The conflict occurred in database 'AbxData', table 'ResMetod', column 'Pet'.
Hope somebody can help me.