>Hi
>
>I have 2 tables, and if one is updated then it's child table will reflect these changes. However, I only want the child table updated if a certain record exists in another table.
>
>Where should I put my Validation in my Trigger procedure? Any ideas?
>
>Thanks
>Kev
Kevin,
Triggers would occur last + Update trigger would occur only if you call tableupdate (with buffering). You could call a tablerevert() instead of tableupdate() if your check is not satisfied.
Cetin