I have a global field as Quantity.
I have a portal.
All I want to do is where is the value of global field lie in the portal.
In above case the value is 350. And it lie between 500 and 100. SO, I want to capture (set variables) of unit price of 500 qty and 100 qty.
So Wherever the value lie in portal, I want to get the previous and next records unit price.
This is my script so far.
Isit better to do with script or it can be done using relationships setup.