Specify a sort order in the relationship to sort by date in descending order. That's an option right next to the one you just selected to allow the creation of related records. :smileywink:
WOW! That was Great. I needed that before on something else and wrote a complicated script to get around it. I don't allow creation of records via the relationship - I use a script to add a new record (because I usually am doing 2 things when creating a record, instead of just one) so I haven't paid much attention to that dialog.
Thank you so much!
Be aware that any portals that use this relationship are also now sorted in descending order. You can override the sort order by specifying a different order in portal set up if this is undesirable.
Another option is a calculation field that uses the Last(relatedTable::field) function return the last related records in the relationship's order.