AnsweredAssumed Answered

need dynamic value list not displayed alphabetically

Question asked by user12488 on Aug 26, 2010
Latest reply on Aug 27, 2010 by philmodjunk

Title

need dynamic value list not displayed alphabetically

Post

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.

Any suggestions?

Outcomes