Create database relationship by MySQL Workbench

Question

I'm try to create a foreign key between tables by using MySQL Workbench. But I don't know why I can't tick the checkbox to select a field in order to map with another field in another table. Maybe it require both field has the same type (and other conditions??) So can you tell me the criteria to create relationship using foreign key and how to do it in MySQL Workbench? Thank you

Answer 1

I'm not a user of MySQL Workbench, but make sure you're using a storage engine that supports foreign keys in the first place. (for example, InnoDB)

See the MySQL documentation for the requirements necessary for a foreign key relationship.

Answer 2

Try first to create a table. And then to add foreign key.