Hi, Jason. How are you defining your calculation and the value list? Is the field's index stored, etc?
I found the problem, I had the calculation resulting in a number and not a text
99% of the it seems to be a stupid fix
- MaterialForm and MaterialProcess are both text fields
- The result of your MaterialFormandProcess field is also text
- I"m also curious that your basetable name is GreenSheet_Gslinitems_PRODUCTS (which looks to me like it might be more appropriate for a table occurrence of the basetable PRODUCTS).
- You're not showing values from a second field, correct?
- Lastly, check your MaterialForm and MaterialProcess fields to make sure they actually contain data that would produce more than one value.