You *might* be able to do that with a "before insert" trigger. The problem I used to always run into with triggers was the "mutating table" error, but I could usually work around it.

Tim