In a mobile geodatabase, sorting a field removes rows from an attribute table with 'Join one to many' between a feature class and a stand-alone table.

Workaround

Use the Export Features tool to export the joined feature class or table as a new feature class. This fixes the issue and the records can be sorted.

Steps to Reproduce