value lists sort

[simoncpage]

Is there any way to sort value lists alphabetically - once some enters a new value into a value list it appears at the bottom regardless of its name is there any script I could run to sort it alphabetically?

Thanks

S

[Lee Smith]

Hi Simmon,

If you base your "Value List" on a "Field" it will always be in Alphabetically order based on the first word.

AFAIK, there isn't a Script or procedure, native to FileMaker, that will allow you to do this to do a "Hard Coded" list. The way I do this is to access the values through the File - Define - Edit list, and then select all of the values in the list, Copy, and then Paste the values into a text editor (excel works too), Sort the list, Copy the sorted list, and then go back to FileMaker[color:"blue"] (Be sure you have the List in FileMaker still selected) and Paste, this will replace the current list with the alphabetized one.

HTH

Lee