AnsweredAssumed Answered

How to show only related values from the same table

Question asked by PeterMontague on Jun 12, 2013
Latest reply on Jun 13, 2013 by PeterMontague

Title

How to show only related values from the same table

Post

     On my sales layout I have a number of locations from which I can choose my product. The sales layout is based on the transactions table.

     I also have my locations in the transactions table. I'd like to see only related locations, and not all locations, in this field i.e. I'd like to click on the field and choose from only the locations from which I can choose the specific product in the portal.

     But I am not allowed choose related values starting from transactions. This option is greyed out.

     This works fine if the field is not part of a portal. But I need it to be part of a portal because some orders are for more than one product.

     Any tips?

Outcomes