I've a simple value list to populate a pop-up menu depending on the value of the rx_kcal_pc field. The VL table has a 'min' and 'max' value for each VL_Eaim_reason and is related so that the 'rx_kcal_pc' has to be more than the 'min' and equal to/less than the 'max'. However, I'm finding that of 3 conditional lists possible, only the one with the lowest 'max' cut-off is ever listed.
I have checked that 'rx_kcal_pc' values are numeric and of values that should change the value list shown.
Are there any other checks I should make?