You'll have to code that manually as you do the insert, stored procedure for insert would probably be best.
Do watch out for concurrency errors, this kind of  thing is not that easy.. (I have a blog post publishing in a couple weeks on this)