Foreign key drop down menu
| User, date | Message |
|---|---|
|
Written by heraldic2
2 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
2 years ago 3960 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
2 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. |