Hello and Yes.
In the Define Value List dialog, select 'Display 2nd Field' (column on right) and Choose a Number field* that sorts the way you want it.
Now in the dialog, select 'Sort by 2nd Field'.
The 2nd field will display next to the Text Values in pull-down, but will not be stored in field after selection (good).
Create a simple Script as follows to force an update to the Value Sort Order Field ( *Table::sort_num ) when Records are added/modified - it could be tied to Trigger that fires when Value List Records are committed, or when the Layout is exited (after editing):
Show All Records
Sort [ Table::text_field ; Values Descending , no dialog ]
Go to Record/Request [First]
Replace Field [ Table::sort_num ; no dialog ] with Serial Numbers starting at 1, increment by 1.
Thanks for the help. I tried your suggestion, and i worked fine, except that the second field appears in the list. It will solve my immediate problem.
You can learn something everyday... if you just listen.
1 of 1 people found this helpful
except that the second field appears in the list
If you have less than ~100 values in your list, consider the workaround described here:
Thanks again. I'm just going to live with the second field being visible. I think I'll avoid the 'space' solution. But thanks.
Where did you trigger the script?