values list sort by category
I have a valueslist that is placed in a "line items" portal called inventory ID. It uses values from inventory ID. it also lists the item name. Right now it sort alphabetically. In our inventory summary page. it sorts by the item category which is much more useful to me. If i try to do this in my values list, it replaces the inventory which is how my tables are referenced. I am sure there is a work-around for this. Thank you.