• Yes, you are correct Sam.

    The OP would have to use an INSTEAD OF trigger and then do the actual insert/update themselves.

    Thankyou. I just realized it.

    It's all about improvising and using the same thing it in different ways.

    Regards,

    Sam.