How to show only related values from the same table
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.