1 Reply Latest reply on Nov 12, 2012 11:41 AM by philmodjunk

    Portal - Loading data to another table

    dansan500

      Title

      Portal - Loading data to another table

      Post

           I am having a problem loading data from a portal (Line Item) to another Table.

           Table name (Storeroom) which contains the fields in the graphic below.

           Table name (Issued) where the line item information is to load.

           Notice: in the below graphic the field called (QTY to ISSUE), I want to be able to enter a number there and hit the SELECT button to load the portal's line item information to the (Issued) table fields with the same names..

           In my script I used the Set Field statement to load the data, but I can't get it to work.

           Can you put me on the right track..

           Thanks

      Portal.png

        • 1. Re: Portal - Loading data to another table
          philmodjunk

               You are probably missing a go to layout step.

               I only see fields in the portal and am not sure which table is the portal's table. I've guessed storeroom for this example:

               Set variable [$Qty ; StoreRoom::Qty to Issue]
               Set variable [$ID ; StoreRoom::__pkItemID]---> I can't tell which field uniquely identifies each item.
               Go to Layout [Issued]
               New Record/Request
               Set Field [Issued::Qty ; $Qty]
               Set Field [Issued::_fkItemID ; $ID]
               Go To Layout [original layout]