drop down list - foreign keys

andyr posted 7 years ago in General
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.

ansgar posted 7 years ago
You can paste into cells without having pressed F2 to start the editor. Just set the focus on that cell and press Ctrl+V.
andyr posted 7 years ago
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.