I have the following fields in my project:
TextFieldA - Text
SignatureA - Date
TextFieldB - Text
SignatureB - Date
When a record is updated ( records are never created in this project - there are only existing records ) I want to do the folowing:
If the content of TextFieldA is changed ( meaning that the value now stored is different from what it was before saving ) the current date should be stored in SignatureA.
If the content of TextFieldB is changed ( meaning that the value now stored is different from what it was before saving ) the current date should be stored in SignatureB.
When a record is updated, TextFieldA and/or TextFieldB may or mat not be changed. If there are no changes - the date fields should not be updated.
Hope you understand what I am trying to accomplish.
Thanks for all help!