Field validation

[Maxwell Morlay]

I presently have two fields that require information to be entered when any changes are made on a record. The user is required to enter her name and date. User gets a beep when exiting if she did not enter name and date. I use the field validation for this task. It works fine until I make more changes on a later date. My fields are validated from earlier editions, and the user gets no beep.

I want the name and date fields to be updated each time editions are made. The simple "update - yes or no" message is okay. This is not a heavy security issue. Your suggestions are always appreciated. Maxwell

[cjaeger]

set the modification to date & auto-enter Modification date

set the modification user to modification user

both options can be found in the auto-enter section of define fields.

If you dont want the username that is registered with filemaker, use a global field plus a 1:1 relation plus a lookup on self::username.