>Hello!
>
>I'm think that your trigger failed because it cannot find record to delete
>in your parent database that is already deleted.
>
>Have a happy day
>Vladimir Shevchenko
>
>> I have a table with one-to-many relationship to itself. The delete
>> option in the referential integrity is cascade.
>>
>> When I try to delete the parent record I receive message trigger failled.
>
>> Why if I use delete cascade?
I just tested it, that's mostly true. The error is an illegal recursion call.
You'll need to write your own code that will delete the children prior to deleting the parent.
BTW, there is a messagebox in the rierror function that is remmed out. If you remove the asterisk, VFP will return a message regarding the reason your trigger failed.
HTH
Matt McDonnell
...building a better mousetrap with moldy cheese...