Yes, I actually have defaults in the full DBC. However, my concern is that if someone INSERT INTO FROM MEMVAR or SET CARRY ON and APPEND BLANK. I don't want the old date. Also, I want the change date to be automatic when the records is changed. The unfortunate thing is that we do a bunch of things from the command line, such as update tables like this. I supposed I could/should make an update form that handles these bits, but I haven't had time.
David
David