>Hi Jim,
>
>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 the primary table.What´s wrong with this ?.I attempted recreating all the referential integrity one more time but the problem persists.
>The insertion rule is
restriction.
>
>Thanks for your help
Marcelo,
If you have the insert rule for the child table set to restrict then you must have a matching parent record and the child's foreign key must be filled in before you can save the child record.
