AnsweredAssumed Answered

Traversing through portal line item

Question asked by gullfounder on Jul 8, 2012
Latest reply on Jul 12, 2012 by gullfounder

Title

Traversing through portal line item

Post

Hi,

   I am very new in File Maker Pro. Trying to learn it. But recently i have encountered a problem. I wanted to make very simple script. I have made a layout with portal in it and a button. A script is attached to the button. When all the required data has been putted.  Client will press the button to trigger the script.

A script will simple traverse through the line items and update the inventory.

Here is what i have written in the script.

 

"Go to Portal Row [First]
Loop
Set Variable [$id; Value:Sale Detail::_fkproductID]
Set Variable [$qty; Value:Sale Detail::Quantity]
Exit Loop If[$id=User Prefrences::null]
Perform Find [Specified Find Requests:Find Records; Criteria:Sale Detail::_fkproductID: “== $id”] [Restore]
Set Field [Product::ProductInStock; Product::ProductInStock - $qty]
Go to Layout[original layout]
Go to Portal Row [Next]
End Loop"

 

Kindly help me fix it.

Outcomes