Thanks a lot Steve this should give me a good start I am going to try it tommorow morning and see how it goes keeping my fingers crossed.

Yes I need both update and insert trigger as well thats where I am stuck and I dont know how to go and do the batch updates for that particular...

Yes you are right John but I need an idea of how the triggers should be since I am new to SQL and there is no seperate SQL guy in...