I'm not apposed to doing at with a trigger but how would I do it in a DBIC model? I figured it would either be some cool way of writing one of the relationships or a trigger - I was mainly trying to do it with a relationship but since you mentioned it, I've been looking and I cannot figure out how to write the trigger in DBIC.