Forum Discussion
In Grid Edit it will sort by the first value in the dropdown by your standard alpha-numeric sorting. So if you want to control that you need to format the string in a way that they sort the way you want. An example would be if you have like a status of Open, Closed, Not Started, you could do 01-Open, 02-Closed, 03-Not Started.
------------------------------
Chayce Duncan
------------------------------
Thanks Chayce! I followed your lead on this and souped it up a bit. I totaled the number of times the parent record had been used via a summary field and then assigned a numeric rank to the string of that parent record description field. If the parent record was used >10 times, then give it a "1 Open", 10 times, give it a "2 Open", etc. In this way, I'll have the most used values appear for each user at the top of the drop-down in the child record grid edit. I will need to test this in the wild but I'm pretty sure this will do exactly what I needed. Much appreciated!
------------------------------
Nathaniel Cahill
------------------------------