run a trigger after record is saved in the table
We need to create a record in the child table when a new record is inserted in the parent table. Since triggers operates with #inserted record (which is not inserted in the table yet) child record cannot be created (we use referential integrity)
16
votes
![](https://secure.gravatar.com/avatar/fdd66b11aaac2f78e91fe258c6e3c833?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)
-
Mike commented
This is a much-needed change. A post trigger instead of the Pre-trigger. I hope we can get more votes for this!