Is there any way to force the sort order of what appears in a drop down list when using values from a field?

eg: Low-Medium-High, not High-Low-Medium (a simple example, others are more complex).

Because I need control over list content to be restricted to one admin account, I am creating the lists from restricted access layout fields, rather than editable custom values.

I don't want a second item in the list, but I also don't want items in alphabetical order. I want them in the sort order of the records/fields the list is compiled from.

(I'm trying to match what the client currently gets in an Access database. If I can't sort it, they'll just have to do with, what is to them, an illogical order.)

Could you explain this part:

Because I need control over list content to be restricted to one admin account, I am creating the lists from restricted access layout fields, rather than editable custom values.

No, value lists based on fields cannot be custom sorted, they are always sorted alphabetically ascending.

Instead use a custom value list.

value list based on fields can not be custom sorted .

Another post that just repeats the previous answer and adds nothing more ...

http://fmforums.com/forum/topic/79906-find-matching-records/page__p__371960#entry371960

value list based on fields can not be custom sorted .

Please do not repeat a previous answer without commet.

Lee

"Because I need control over list content to be restricted to one admin account, I am creating the lists from restricted access layout fields, rather than editable custom values."

All users but one, have 'Staff' access (editing-only, locked out of a couple of layouts). I have one other user, call him 'ClientAdmin', he's actually editing-only, but does have access to a couple of extra layouts.

I could only use an editable custom value list, if I could make it non-editable for all users but 'ClientAdmin'. Can I give different custom value list access rights to different accounts?

"I could only use an editable custom value list, if I could make it non-editable for all users but 'ClientAdmin'."

Yes, you can.