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

drop down list - foreign keys

User, date Message
Written by andyr
4 years ago
Category: General
7 posts since Tue, 27 Mar 07
Hi, I have a request for a change in the foreign key drop down list. This is related to http://www.heidisql.com/forum.php?t=5736

At the moment, if a table has < 1000 rows, it lists all the foreign keys for selection. However, my normal pattern of usage is I copy a primary key value to clipboard, and want to paste it into the foreign key column. When the drop down is displayed, i cannot do this and have to type the value in, or select it from the list. Some of the values are long and prone to typos!

Could the drop down accept input when using ctrl+v, or is it possible to have an option to disable this functionality? I have tried disabling 'enable pulldown editor' but this doesn't seem to affect it.

Thanks,
Andy.
Written by ansgar
4 years ago
4977 posts since Fri, 07 Apr 06
You can paste into cells without having pressed F2 to start the editor. Just set the focus on that cell and press Ctrl+V.
Written by andyr
4 years ago
7 posts since Tue, 27 Mar 07
So you can - thanks so much anse! Can't believe I didn't spot that.
 

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