Locking pulled related field (or how to make a copy of the record)?
I have a small invoice management FM Pro system. One parameter that is use in invoices table is pulled from customers' table.
Is it possible to lock (freeze) as historical that pulled parameter in invoice table to prevent overriding it by the new value entered in customers' table?
I need to keep it as historical value in invoice table, but still have actual value in customers' table for current and future use (until again modified).
Thank you in advance,