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
• Status: Verified
• Category: MySQL Workbench: Modeling
• Severity: S4 (Feature request)
• Version: ALL
• OS: Any
• CPU Architecture: Any

[26 Oct 2010 9:43] P Musolf

Description:
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.

Example:

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:
NA

Suggested fix:
Pulldown field...

[28 Oct 2010 15:10] Alfredo Kojima

Thank you for the feature suggestion.