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
- just modify that table as you want