oK if anyone remembers the problems with my Update/termination Trigger I found it works best if I do it as a Stored procedure instead of a trigger. Thanks again for your help guys. I really appreciate it
thank you Brett for advice I think I'll take it especially since I'm still in the learning process and you guys are the experts. I can have a update query instead. the only thing is my users are not familar with databases at all.