Set Variable from Portal row

[JMart]

hello, having an issue that cant figure out why its not working. 

Have a portal in a layout (Table: Customers), showing all records from the same table (Customer). all works well, meaning all records are showing in the portal. now I am trying to create a record via a button on the portal row in a different table but cant get it to work.

in my script I have the following steps;

This script runs via a button which I have on the portal row. 

all the steps appear to be running except the "set variable" is not pickup the selected row but whichever record its active 

Can someone give me an idea what I could be doing wrong. 

 

Thanks

JMart

Edited November 8, 2018 by JMart

[comment]

You have a self-join relationship, which means you have (at least) two occurrences of the Customers table on the graph. In order to set the variable to the value that appears in the portal row, you must use the occurrence that is used to populate the portal.

[JMart]

Thanks. works like a charms