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?
Add a simple query:
SELECT * FROM "table" ORDER BY "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.
Perfect! Just what I was looking for.