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 3 days ago
    Edited by Mark Makarsky 3 days ago

    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