Yes - Triggers can do this ...
If the clients are talking to the DB with stored procedures, just changed the SP! If they're not using SPs, then this is only the start of a lot of pain
Have a look at
An Introduction to Triggers[
^]
On inserts, the triggers get a table called
inserted
- just modify that table as you want