sorting/ordering a value list

[elektra]

This is a simple question, but I can't seem to get it to work. I just want my value lists to be in numeric order. The list is based upon an actual field, so it is dynamic. I have that field sorted in numeric order, but I can't understand why the value list that its based on won't sort in the same order. Any comments would be appreciated.

[Ocean West]

What version of FMP are you using?

Is the field you are using local to the file or related? Is indexing turned on for that field? Are you using a 2nd field to show in this value list?

[elektra]

I'm using fm 4.1. The field is a related field. It is indexed and I am using the "also show values from this list" option.

[Kurt Knippel]

The Value List will not be able to sort related values. Try instead creating the value list in the related file and then simply using that value list in your other file.