Access->Mysql

[chesco1980]

de la clave foranea

CREATE TABLE `his_pie` (
`id` INT(10) NOT NULL auto_increment,
`id_pedido` INT(10) NOT NULL DEFAULT '0',
`id_articulo` INT(10) NOT NULL DEFAULT '0',
`cantidad` INT(10) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `id_pedido` (`id_pedido`),
FOREIGN KEY (`id_pedido`) REFERENCES `his_cab` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) TYPE=InnoDB;