>Hi all,
>
>I have problems when I try to add a new record.I have two tables both relationed.The message "Insert trigger failed" fires when I´m attempting to add a new record.
>I tried changing the indexes of both tables(Char to Integer) but nothing happened,also I validated it.The Ref.integrity is :
>
>1)Update,2)Delete,3)Insert = 1)Cascade,2)Restrict,3)Restrict for both tables.
>What can I do ? I need this configuration for my Ref.Integrity.
Add the record to the parent table first, and make sure that the foreign key is filled in when adding the record to the child.
Erik Moore
Clientelligence