Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Data entry Dropdown list foreign keys

k22's profile image k22 posted 1 month ago in General Permalink

Hello, I noticed that when I enter data on some FK linked field the drop-down list presents values in a random order, is there a reason for that? Other FK linked fields come in alphabetical order and it's highly helpful when entering data.

Thank you, happy day!

ansgar's profile image ansgar posted 1 month ago Permalink

HeidiSQL loads the foreign values, mostly integers, and the first text field from the same table, and sorts the latter one alphabetically.

If that doesn't seem to work, you should post a screen and the query from the SQL log here.

k22's profile image k22 posted 1 month ago Permalink

Thank you for your reply! Sure, I send it now

2 attachment(s):
  • fkdd
  • screenshot
k22's profile image k22 posted 1 month ago Permalink

Got it, issue solved, thank you very much for support!

Please login to leave a reply, or register at first.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.