I have two tables: SAVINGS and TRANSACTIONS
SAVINGS is related to TRANSACTIONS
Not every TRANSACTION record is associated to a SAVINGS record, but when I do add a savings record to TRANSACTIONS (making TRANSACTION field FK_SVG not null) I want the value from SAVINGS (nbr_PCT_SVG) to be placed in TRANSACTIONS field (nbr_PCT_SVG_T) but I want it stored there for achievable purposes i.e. not changed in the future.
How do I do this? Trying to do this via a calculation won’t let me store it because it’s a calculated amount.
Do I need to use a Value List? A ‘OnRecordCommit’ script trigger? What would it look like?