My case:
I have to tables A and B. Both of them have columns named 'ID'.
I want to remove records from table B, after insert record to table A. For example, when I insert to table A record with ID = 50, I want to remove from table B all records when ID = 50.
I wanted to use 'After Insert' trigger, but there is no option 'Delete Record' in other table.
It's worth adding that in my case I can't use sql query to delete records.
Any ideas?