locking fields

[john j]

What is the best way of locking a record so it cannot be modified(text field) that is made on a different date than today. I want to be able to edit and change records made today but not to accidentally modify records made on previous days. This data field is a text field(s) that contain patient data that should be "locked at midnight".

thanks,

john

[Raybaudi]

Hi

a way is to create a date field (date) with option to auto-enter the date of creation; and to put this calc into validation option of your text field:

date = Get ( CurrentDate )

BTW: this isn't the best way, maybe the simplest :)

[john j]

I was trying to do this with privilege restrictions but using a get command with a calculation may be the best.

thanks,

john