Skip to main content
Question

How to sort Lookup field

  • August 19, 2022
  • 0 replies
  • 116 views
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
------------------------------
    This topic has been closed for replies.

    • MarkMakarsky
    • Registered
    • March 18, 2023

    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
    ------------------------------

    Terms & ConditionsAccessibility statement