Base table shows records in a strange order

[agerber85]

I have an .odb that is the frontend for a MySQL database. Is there a way to force the tables to order by the primary key when I open them in Base?

[Villeroy]

Add a simple query:

SELECT * FROM "table" ORDER BY "primary_key"

[Ratslinger]

@agerber85

way to force the tables to order by the primary key

If dealing with Table Data View then they open in the method last sorted in:

So just sort on your primary key column:

Then save Base file when closing. Sort sequence will remain as last selected.

[agerber85]

Perfect! Just what I was looking for.