Bug #57733 During data insert/update show foreign key values
Submitted: 26 Oct 2010 9:43 Modified: 28 Oct 2010 15:10
Reporter: P Musolf Email Updates:
Status: Verified Impact on me:
Category:MySQL Workbench: Modeling Severity:S4 (Feature request)
Version:ALL OS:Any
Assigned to: CPU Architecture:Any

[26 Oct 2010 9:43] P Musolf
It would be nice if you add/update data in a record and you come on a field which must contain the value of an other table (foreign key), that you make a pull down menu with the data you have to choose from.


Table : country

Country.code  char 3 (unique key)
Country.name  char 30

Table customers

Customer.number   (unique key)
Customer.name    char 50
customer.country code  char 3  ---> Foreign key to country.code

If you update a row from the table customers and you reach the field country it would be nice if you can choose from the values from table country.

How to repeat:

Suggested fix:
Pulldown field...
[28 Oct 2010 15:10] Alfredo Kojima
Thank you for the feature suggestion.