Sort And View Records By Category In. Suppose we have the below table that contains employee data. Place Index on Rows between Region and Sub-Category.

Sorting of records in FileMaker is achieved using the Sort Records dialog. Double-click the heading of the column you want to sort. The dialog is available via Sort-Records in the file menu and as a script step.
Sorting of records in FileMaker is achieved using the Sort Records dialog.
You can also right-click a fields heading and click Sort Ascending or Sort Descending. Under Compute Using select Specific Dimensions. So only this ORDER BY can be guaranteed to work. Go back to Design View.