How to sort Lookup field

Question

I have master table in which I have Date, Description and Icon (All are sorted in descending order). But when I looking them in child table they are not sorted in descending. I want them in ascending order of date. Thank You!
https://drive.google.com/file/d/1M7tlnl1ela8LZu92Z11x0r0yuMWPzhLU/view?usp=sharing

------------------------------
Amedha Surve
------------------------------

markmakarsky · Answer

You can do this by editing the form field by selecting "Properties" Change the Default Record Picker value (or whatever value you have in "When used for data Entry:") to a Report, such as List All. Click "Change Settings" and under Sorting and Grouping select the "Sort or group on other fields" Choose what field to sort on. I make a use a numeric field I created specifically to sort in numbered order to keep my sort specific to my needs.

------------------------------
Mark Makarsky
------------------------------

------------------------------Mark Makarsky------------------------------

Forum Discussion

How to sort Lookup field