What you need is a TRIGGER:

http://msdn.microsoft.com/en-us/library/ms189799(v=sql.105).aspx

If you post your table schema, I will put together a sample trigger for you.

Matt