>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
In this case what you can in your trigger for the insert and update is to check if the value is updated like.
IF ChangeDate<>DATE()
=MessageBox("Please make sure....")
return .f.
ENDIF
This way at least you might get the attention of someone that does an update/insert.
The form of course would be better.
Yelena