MySQL Bugs: #33052: UI for Choosing "Referenced Column" does not make sense

Bug #33052	UI for Choosing "Referenced Column" does not make sense
Submitted:	6 Dec 2007 23:35	Modified:	6 Dec 2007 23:56
Reporter:	Roland Bouman	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:		OS:	Any
Assigned to:	Alfredo Kojima	CPU Architecture:	Any

Description:
In the table editor one can define a foreign key. 

In the foreign key tab page, you can choose the columns to map. This requires you to 
1) click a check box right in front of the column in the FK
2) choose the referenced column from a list box next to the fk column.

Well, it seems to me that the 2nd action should suffice, and by intuition, this is the first thing you do. When you do make this "mistake" the checkbox is not automatically checked. When you check it manually instead, the referenced field is removed from the listbox so you can start over again. 

This really makes me curse this interface!

How to repeat:
see Description. I can provide screenshots to explain all steps if that is not clear enough

Suggested fix:
Suggest to remove the checkbox alltogether. Let the user choose from the listbox, en let that be the mapping. add a litte red X button after each fk column mapping to undo the association. 

alternatively, leave the checkbox be but check it when the user happens to select from the referenced column before checking the checkbox.

Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release.

If necessary, you can access the source repository and build the latest available version, including the bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html