Current behavior

• currently sorting of the data in the drop-down is alphabetical only

Expected behavior

• when filling in data using HeidiSQL, it's actually easier to not have a foreign key constraint because then you can type a value. With a drop-down it get complicated.
• when the drop-down is there typing a 1 will show the key first that starts with the '1' but might be a 11 because the name behind it rank higher in the alphabetical sorting

Possible solution

• an option to sort by the key that's actually in front of it
• option to have a drop-down but still be able to type a key value as if it was just a textbox but then refuse to update the row if that entered value doesn't exist in the key constraint

Environment

• HeidiSQL version:
  9.5.0.5253
• Database system and version:
  Maria DB 10.x & MySQL 5.7.19+
• Operating system:
  Win10 1709