Many thanks for replies. I have bypassed the trigger method and updated the table direct and so far so good. I am not sure why it was originally...

Thanks very much for the reply and script.  Very usefull!