distal-attribute
distal-attribute
distal-attribute
distal-attribute

Foreign key drop down menu

User, date Message
Written by heraldic2
3 years ago
Category: General
3 posts since Wed, 26 Oct 11
Greetings,

I love HeidiSQL, I was just wondering if there is a way to change the order in a foreign key drop down menu.

An example:
table1 has three columns (id1, first_name, date)
table2 has the columns (id2, id1, info) Foreign Key table1.id1 = table2.id2

When filling in table2 information you use table2.id1 as a drop down. This drop down has 2 columns listed. id1 and first_name. This is done so you know what id1 is, however it is ordered by first_name.

Is there any way to set the order by to id1 instead of first_name, and still see first_name?

Thank you for your time
Written by ansgar
3 years ago
4932 posts since Fri, 07 Apr 06
No, that's some hardcoded part in HeidiSQL which guesses about what the user wants to have displayed in that drop down.
Written by heraldic2
3 years ago
3 posts since Wed, 26 Oct 11
Thank you very much for the reply anse
 

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