Forums | Webyog
Tools to manage and monitor MySQL databases
forums › forums › SQLyog › Using SQLyog › foreign keys
First of all change the table handlers to InnoDB table type. For more information about InnoDB table handlers visit http://www.innodb.com
There is a very nice tutorial on setting up FK using SQLyog at http://www.weberdev.com/ViewArticle.php3?ArticleID=352. Check it out.
All participating columns must have indices, not just the referenced ones!