Foreign key table hint when adding new record

axelbest's profile image axelbest posted 10 years ago in General Permalink
Is there a way to add a "foreign table column alias" column (or something like that) in the foreign key table? Right now when i add a foreign key relation, and then i add a new record manually - i get the foreign table second column (usually it comes after id..) Is there a way to customize it ? E.g. I have a table A which has foreign key "movie_id" pointing to movies table id column. Movies table has columns id,author,length and title, and when i add a record to table A i always get the author of the movie hint when i choose id from the select list, and it would be very helpfull to choosse between author/length/title. I know i can reorder columns so that title would be after id, but it will force me to reorganize my code. I hope you'll know what I meansmileThis funcionality would be awesome.
ansgar's profile image ansgar posted 10 years ago Permalink
HeidiSQL automatically uses the first text field for the foreign value drop down. This is currently not customizable, and I have no clue how a custom value selector should look like and where it should be placed. Currently, you can just activate and deactivate this pulldown, in Tools > Preferences > Data editing.

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