drop down list - foreign keys

User, date	Message
Written by andyr 3 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 3 years ago 3973 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 3 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. Username: Password: Remember me