Sorting a value list by a summary field

[jdu98a]

I found a huge post that seemed to be roughly about what I'm trying, but I couldn't find an applicable solution. Here's what I want. I have a value list that is made up of values from my "product_name" field in my inventory table. I would like the value list to be sorted by my "product_category" field, also in my inventory table.

So instead of this:

Product 1

Product 2

Product 3

Product 4

Product 5

Product 6

It would look like this:

Category 1-

Product 1

Product 2

Product 3

Category 2-

Product 4

Product 5

Product 6

Any suggstions?

[mr_vodka]

You can create a concatenated field of Category & " - " & Product. A value list sorts Ascending order automatically and unfortunately can be limiting.