Data entry Dropdown list foreign keys

k22's profile image k22 posted 4 years 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 4 years 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 4 years ago Permalink

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

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

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

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