I figured I would have to go with the trigger but I just wanted to make sure I wasn't missing something.

The constraint will not really work in my situation because...