Setting an OriginalDate field to retain the first date the Date field was set to
I'm wondering if anyone could help as to the best way to accomplish this 'simple' task as i'm struggling with it at the moment. I am new to FileMaker and databases in general so please forgive my ignorance
I have a table of service visits in the database in building at the moment with two fields, on called 'Date' and the second called 'OrigonalDate'
I would like the OrigonalDate field to capture the Date field contents if the Date field is changed so we can always retain the first date we set for a service visit. If the date field is subsequently changed again then the OriginalDate field would remain unchanged.
I have tried to do this in the table field calculation so it is changed at the table level as opposed a script trigger to fill the table.
Many thanks in advance for any advice