>I have problems with two tables in my client database.Both tables have a simple
One to Many relationship.When the user attempts to insert an entry in table2, it shows an error that say "Insert trigger fail".Then when I going to look for into both tables, I see that in the ID field appears the name of the Client in each table.What´s wrong with this ?.I attempted recreating al the referential integrity one more time but the problem persists.
>The insertion rule is
restriction>Please, anyone can help me?
>
>
Thanks for your helpHola Marcelo,
Check for the validation rule. For most cases, the insert trigger should be set to CASCADE.
José