1 Reply Latest reply on Oct 13, 2012 2:45 PM by schamblee

    Duplicating record in another table

    ShaikhAtta1238

      Title

      Duplicating record in another table

      Post

           Hello, 

                      I have a table where pre transactions are entered with the below fields:

           Table: PreTransaction
           Account Name
           Date
           Transaction No
           CreditAmount
           DebitAmount
            

           Now what script can I use so the record in the above can duplicate in the post transactions table.  The record will duplicate by a script and when the script button is clicked it should move the record fields to the post transaction table. 

           Table: PostTransaction
           Account Name
           Date
           Transaction No
           CreditAmount
           DebitAmount

           Thanks

        • 1. Re: Duplicating record in another table
          schamblee

               It's consider standard practice not to duplicate records in this matter, the recommend method is to have a field that States Non-posted and after posting changing to Posted.   Take less space and get the same results.

               That being said you would have to have to use

               Set variable [ $Account Name ;Value:PreTransaction::Account Name]

               do this for all fields

               Go to Layout [the layout]

               this would be the postTransaction layout

               then

               New  Record/ Request

               Set Field [PostTransaction::Account Name;$Account Name]

               repeat for all fields