Regarding Nested Trigger

Multpile netsted transactions can be handled different ways.

You could use the Save Transaction to commit part of the larger operation, so that if a later part fails it doesn't undo everything, only the parts after the save. (Transaction Save Points)[^]

You can read mor in the Advanced Transaction Topics[^]