I ended up using an OnNewRecord event in my data module to handle the
default fields. I just rather do that than add DB triggers to check and
adjust. There are other fields with defaults that can only be set in the
client so I might as well do them all there.

Thanks....

Allen.