View Only
  • 1.  How to sort Lookup field

    Posted 08-19-2022 05:32
    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!

    Amedha Surve

  • 2.  RE: How to sort Lookup field

    Posted 03-18-2023 11:52
    Edited by Mark Makarsky 03-18-2023 11:52

    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