AnsweredAssumed Answered

Script help

Question asked by SamBeardsley on May 3, 2013
Latest reply on May 4, 2013 by SamBeardsley


Script help



     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?