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

Foreign key table hint when adding new record

User, date Message
Written by axelbestMoney, Euro
5 months ago
Category: General
4 posts since Mon, 03 Feb 14
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.
Written by ansgar
5 months ago
4940 posts since Fri, 07 Apr 06
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.