I have a table ('main'), one of whose fields ('staff_id') refers to another table ('staff'). The dropdown menu from the 'staff' table is sorted by the 'staff_name' field, but I prefer it to be sorted by the "id" field. How to do it? Thank you!
How to sort the FK dropdown menu by 'id', not by 'name' ?
HeidiSQL takes the first text/varchar column for sorting, and you cannot change this behaviour.
I am planning to replace that dropdown editor with a dialog supporting features like sorting, filtering and more. See issue #762 for updates.
Please login to leave a reply, or register at first.