2 Replies Latest reply on May 4, 2013 7:36 AM by SamBeardsley

    Script help



      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?