I need to sort my result page so that the record that the oldest record shows on top, the second one afterwards, and so on.

I found that if no sort field is specified I get just the opposite of that. I could use the ascending/descending sort option to solve this problem but "-sortorder" doesn't seem to work when no sortfield is selected.

Any ideas?

Thank you in advance

Technically, an "unsorted" database is actually in chronological order, with the oldest record first and the newest last.

Carefully check your CDML code and see if there is a sort happening somewhere.

Alternatively, define an auto-entered serial number in your file (remember to serialise all the existing records after you define the field) and sort by this serial number ascending in the CDML.

first, thank you for your promtly answer Vaughan.

You are right. Unsorted is just how you say: the OLDER the first, the newer the last. I was wrong when watching at my records.

Anyway, it's good to know that if I wanted the opposite I would have to use the autoenter ID number from filemaker itself.

Hi soci222, To reverse sort (descending) you can also create a calculation number called RecordID with Status(CurrentRecordID). I don't usually like to encourage calculations if other more resource-friendly means are possible but it's a down-and-dirty way to accomplish the job quickly. And I find myself using RecordID for specific relationship needs and its value outweights the small resource cost.

MoonShadow