Hi Matt and thank you very much !!!! Now I get the point .... I'll have to decide if I maintain these two tables in MyISAM or if I drop the AUTO_INCREMENT and change the source-code in Delphi.
It's clear now that the problem is the lack of support of InnoDB. Thanks for your help and regards, Fred. > Hi Fred, > > InnoDB does not support AUTO_INCREMENT on secondary columns of a > multi-column index. > > > `id_registro` int(11) NOT NULL auto_increment, > > PRIMARY KEY (`id_formula`,`id_registro`) > > There: id_registro is the second column of the index. > > > Matt
