Is there a way to have your multiple choice text field sort in more ways than alphabetical or "Order shown here"? Or put another way, is there a way to select what "Order shown here" refers to?
I have a source table that is a list of active and inactive funding sources. I am using this as a global pick list for multiple tables in my app. I want it to display active funding sources first, with inactive below. i.e. sort active first and inactive second. Ideally it would also be alphbetical after the active/inactive sorting. I tried setting the default report to have the proper formatting, when you open the table it displays how I want it, but the field list in the other tables are either based on when the data was entered (order shown here) or just alphabetically.
It appears that "order shown here" is based on the row number.
Any advice would be greatly appreciated.
------------------------------
Ryan Williams
------------------------------
