Setting a value in a different form

Setting a value in a different form

Ok, this is related to forums.zoho.com/viewtopic.php?t=113422&sid=29949020c010d9cc2d9c254f1670e3b3

I want to update a seperate form based on activity on the current form. Why? Becuase I can't seem to figure out how to create a view based on multiple forms. Is there a way to do that?

So what I am attempting to do is on the Product page, add the following code to the "On Success" action which should chnage the Product_Notes.market_hidden field to the current selections.

y = "";
t = Product_Notes [ProductName == input.ProductName];
t.market_hidden = "";
for each MarketSpaceLookup r in Products
{
if (y == "")
{
y = r.MarketSpace;
}
else
{
y = y + ", " + r.MarketSpace;
}
}
info y;
t.market_hidden = y;
















It does update the field in Product_Notes, but it lists the last four selections regardless of what is actually selected.

Any help please?

Thanks