• Bhaskar.Shetty (5/23/2013)


    Insert Happens mince do you mean by AFTER INSERT OR INSTEAD OF INSERT, if it is after insert you can create three seprate triggers or suggsted in previous post or use output parameter as I described , If it is INSTEAD OF INSERT the mail insert will not fire in its place you can update other table as required.

    Just play it simple. It's upto your choice what you want to achieve. I just gave two options. 🙂

    In between, would love to see how it worked.