need dynamic value list not displayed alphabetically
I have a drop-down list I'd like to populate dynamically from a list table (of over 200 records). List must be displayed in one of two orders (either of two indexed serial number fields) but drop-down displayed option needs to be calculated field (2 other fields in table).
I'd first tried using value from 1st field but this is not adequate for informing a choice. If I choose to show value from 2nd field, FM sorts by this field. That's my problem--I need to order non-alphabetically. Am running into a wall.