When a database is hosted, there are many settings that are not stored after closing connexion with the file. Sounds like this is one of them.
As a workaround, you could close the file with FMS Admin Console, open it locally with FileMaker Pro, Go to DataBase Management to sort Fields by name, close the file and reopen it via FMS Admin Console.
I tried your hint but it doesn't worked. Table names are still in creation order. :-(
Very strange indeed.
Maybe because in my rapid explanation i talked about to sort fields by name although you talked about sort tables by name.
But your screenshot illustrated Fields name and not Tables name...
I can confirm there are two different settings.
I have seen cases where hosted files stubbornly refused to list fields on a client in the order specified for it before uploading it to the server. We took a copy of the file, recovered it with recover reporting no problems found. We uploaded that copy to the server and then found that the problem had been corrected.
It would not surprise me to find that the same might happen with a a list of table occurrence names.
The screenshot shows the list of table names available from another database.
With FM sharing 'on' it works as expected but not over FM server.
Before to answer i did a little test and it worked for me.
I made two copy of a file, the first file with order defined Table and Fields by creation order and the second file Table and Fields by name.
My config is :
- FileMaker Server 13.0v5
- FileMaker Pro 13.0v5
- Mac OS X 10.8.5 both side
I think i now located the appropriate dialog. This is Table list and not Table occurrence list. So the order must apply.
However, we can see the file active is not the current file but one called "Janus II", an external datasource.
So are you sure you executed the procedure i indicated previously on "Janus II" related file ?
Is it a FileMaker or an ODBC datasource ?