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

Foreign key table hint when adding new record

axelbest posted 9 months ago in General
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 posted 9 months ago
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.