Is there a way to change the order of a value list when defining from a field? Let's take for example;

Table "Blah"

NAMES

JIMMY

BOBBY

RAUL

ANDY

a value list defined by NAMES from Table "BLAH" will come up in the pop up list like

ANDY

BOBBY

JIMMY

RAUL

.. is there a way to enforce the order listed in the field as the order that the values come up in the list? Or is the alphanumeric sorting undoable in filemaker?

Thanks,

Joel

It is Alpha sorted, yes.

If your list is long, use a portal in a pop-up window and defince the order of the related records with another field, which the relationship will sort upon.

Do you have a serial number entered with the NAMES data? If you do then you can do a value list from the field NAMES showing the serial number field and sorted by serial number which would put the names into the list in the order entered (however, it does have the disadvantage of showing a serial number as well)

I tried to sneak it past the value sorter by placing the a numeric order before the text string and blanking out the order by fonting it as white. No dice. Anyhow, I've decided to just go ahead with a two field value list as slimjim mentioned.