Hopefully this doesn't post twice, i lost my first post.

Hello Group!

I have a Table "System Utility" with a pop-up menu that displays the
following description choices for an user to select a sound type of
low, medium or high. This pop-up pulls from a separate related table
(relationship through the corresponding field "sound_description". The
related table is
Table "Sound Lookup"
with fields
Sound_Value (A code of 1, 2 or 3)
Sound_Descrition (low, medium, high)

and my Table System Utility has fields:
Sound (stores the user selected sound description from the pop-up
menu)
Sound_Value (calculated field from Sound Lookup::SoundValues) - I need
this field to export the numerical values associated with the sound
description of low, med, high).

It works well, but it currently sorts the pop-up menu alphabetically
by sound description - so it reads "high,low,medium".

I'd prefer it to sort by the sound value instead (so that it actually
reads low, medium,high in the pop-up).

The only way I can see to do this is to include the value in the pop-
up and then select the option to sort from the second field. But I
don't want users to see the codes, only the description.

Does anyone know how to do this?

It's not a huge deal for this field, but I have many other (longer)
fields where this will be an issue.

Much thanks!
-learning cat