Unique list issue - Help

[Stephen_Flournoy]

I have a list of client orders. Fields are Job Number, then PO number, item, description and amount
I want to display a page in Glide Pages that shows all active Job numbers. I want to use the custom component (I think) and have the top level show only the unique job numbers, then inside the next level of the component show all the Pos. I’m puzzled on how to do this to get the list of unique job numbers.

[Jeff_Hager]

This is the general concept. Let us know if you have questions.

Filter out duplicate items

Just throwing this out there for consideration. Would it make more sense to have a separate Category table and Production Table? Seems like you are trying to dual purpose this one table for use for both Categories and Products. I can see the potential problem here, but you example is confusing. You show Nike and Adidas and say that they will both see duplicates. How would that be the case if you are filtering by business? I think your example should be showing the fact that you have two r…