field cannot be modified once created

[TASC]

Hi,

I have a question in regards to field validation. I need to be able to validate whether a field has been changed. eg.

user_name field should only be modifiable upon data entry. After the field has been set with data for the first time, it should no longer be modifiable. How could I do that in a validation of the field?

Thanks in advance

[Quartekoen]

Does the field validation have to be immediate? Because if not, you could always allow for data entry, then have a button for confirmation that brings the user to another table to display the information, while not being modifiable. Immediate validation can be dangerous, since it requires the user input correct data the first time, every time.

[Courtney]

I have done this by checking the date the record was created against the current date. I have a timestamp field (Creation Date) which holds an auto-entered date and time the record was created. Then in the validation of my secondary field, I use:

If ((Get ( CurrentDate ) = GetAsDate ( Creation Date )) ; 1 ; 0 )

This way they can edit the information during record setup if they catch a typo or mistake, but after the initial date, they can't change without an administrator.

~C