How to "shape" data from a "Lookup Table" used in a combo box

I am getting data for a combo box back from a lookup table. The column ,in the lookup table, we use has a value used in several rows(I will include screen shots of what I mean). The problem is I get the same value multiple times in my list. There is a property to check that says “Show Distinct Items” but this does not help. What I need is to display only one occurrence of the item.

image

image

image

1 Like

I went ahead and added a support ticket. I found some documentation and to me it sounds like that check box to show distinct items should do exactly that.

Got a response from Epicor. Screenshot below. Anyone know of a work around until it gets fixed?

image