control the sort of the value list

[swf]

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

[Lee Smith]

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

Untitled.fp7.zip

[swf]

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

[Lee Smith]

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

[mr_vodka]

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.

[swf]

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