MySQL Bugs: #50265: A better foreign key selector

Bug #50265	A better foreign key selector
Submitted:	12 Jan 2010 5:33	Modified:	14 Jan 2010 5:56
Reporter:	hamza hamza	Email Updates:
Status:	Won't fix	Impact on me:	None
Category:	MySQL Workbench	Severity:	S4 (Feature request)
Version:	5.1.18	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
when we go to foreign keys table, we will type foreign key, and select the referenced table from a list, it would be nice if we also select the referenced foreign key from a list, this will make the work much easier, because now we have to go to the refrenced table , select the column , and copy the text from there , go again to the 1st table and past the text in foreign key textbox 

How to repeat:
a feature request

Suggested fix:
It would be nice if we select referenced table from list, then select referenced column from a list.

currently, you should be able to select both name from a dropdown control. on Foreign-Key-Tab, enter the FK-name, then select the target-table (as you already mentioned). once you seelcted the target-table, you can activate the checkmark in the column-list on the same tab and select a corresponding column from the dropdown next to the source column. Be aware that both columns need to be of exact same type (including the type-flags), otherwise WB will refuse to link the columns into the key.

could you try to describe how you would like workbench to behave?.

you said
"on Foreign-Key-Tab, enter the FK-name"
why we need to type at all? this is the question
a foreign key is a reference from table1.column1 to table2.column2, every thing is known for the program , the user already designed those tables , and type "enter" all these informations(names). why he will need to enter FK-name again from the keyboard.
1-select the referenced table2 from a list
2-select the referenced column2 from a list  (this will make our experience much easier)
3-the rest is the same as you mentioned

You don't need to type the name you just need to click into the blanc field.

The name will be given by automatism.

Every constraint needs to have a name. That is given by SQL Standard.

If you don't ive a name then the system (either Workbench or the server) will name it randomly.

But there are some usecases for which a user needs to set his own names.