Attached sample file. I want to pull down my employee field and see a list of employees sorted by their job category not alphabetically. When I ask filemaker to sort by the second field, it shows the first of each category not the whole list. Any way to work around

Untitled.fp7.zip

Not sure exactly what you want, but this may be what you want,.

Untitled.fp7.zip

Let me clarify further. You have recreated the exact problem I am having. When sorting by the second field only 4 total values in the first field come up. The first of each category (ast.mgr, mgr, employee, owner).

I would like all the employee names, not alphabetical but in chunks by their job category.

See the attached screen capture

This is the expected behavior for a value list.

They will only show one value for each unique value. Maybe a Conditional Value List will do what you are wanting.

Untitled.fp7.zip

You can try and create a value list based off a calc concat field of Category & " - " & Employee

Then your value list will be sorted by Category and Employee.

Otherwise, as Lee stated, it will only show the values once in the list.

The concatenated field did the trick. That is a great workaround.

I uploaded the sample database with correction.

If anyone wants to view it.

Thanks

fixed.fp7.zip