AnsweredAssumed Answered

Copy a multiple Record to another Record in Portal Row

Question asked by Phyre on May 20, 2014
Latest reply on May 26, 2014 by Phyre

Title

Copy a multiple Record to another Record in Portal Row

Post

     How will I copy a field to another table portal row?
      
     My data go this way.
      
     I have a table of ITEM TABLE, PURCHASE  TABLE And BALANCE TABLE. 
     <ITEM>
     Field:  ItemName
     Field: Quantity
     Field: Price
      
     <Purchase> (Inside this table I have a portal row from <Balance Table> where I want to aste my record copy from Item)
     <Balance>
     Field:  ItemName
     Field: Quantity
     Field: Price
      
     The problem is I dont know what script steps to use. I try this scrips steps but only the itemname has shown
      
     (1) Script steps
     Set Variable {$ItemName; Value:;Item;ItemName}
     Go to Layout {"Purchase Item"Purchase}
     Go to Portal Row {Select First}
     Set Field {Balance::ItemName}
     Go to Record/Request/Page {First}
      
     (2) Script Steps
     Set Field {Item::ItemName}
     Copy {Select; Item::ItemName}
     Go to Layout {"Purchase Item"Purchase}
     Go to Portal Row {Select First}
     Paste {Select: Balance:;ItemName
     Go to Record/Request/Page {Next:Exit after last}
      
      

Outcomes