>Hi
>
>Is there a document that I can read that outlines the default values I can set for fields within SQL-alter table screen? I've worked out how to use default values, but what about using formula, for example, to insert the datetime a record was created, viewed or updated etc?
>
>Regards
You can put in Default value (GetDate()) so current date and time to be default value for datetime field, but default vaules are used only if the field is empty. If field has some vaule it never change, you must change that filed by yourself or you can crate a trigger to do that.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.