I have one number field - 'Total Weight' and another drop-down list field 'Product'
What I would like is to only show certain items in the drop-down depending on the Weight entered.
What I've tried is created another calculation field that would return me a list depending on the Weight value
and in the layout mode have set my dropdown box to display data from that field.
This works only once when I enter the 'Weight' for the first time. After that if I change the weight the drop-down doesn't get updated at all.
What's the best way to approach this?