Victoria and Robert Thank you for your help. I think it is solved.
The error was (as Robert said) "ERROR 1005: Can't create table './alex/jmf33.frm' (errno: 150)" I aslo checked "SHOW INNODB STATUS" where I was redirected to http://www.innodb.com/ibman.html There I found a link to a document saying that I must create INDEXes for FOREIGN KEYs to work properly. I tried the example in that document and it works. Thanks again. Any explanation why I never bumped into this before ? jmf __________________________________________________________ O email preferido dos portugueses agora com 100Mb de espaço e acesso gratuito à Internet http://www.portugalmail.pt/servicos/email/gold/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]