Query inside transaction

The first table (in my above notation):

Code:

fitem_name_1 | CREATE TABLE `fitem_name_1` (
 `fin_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 `fin_name` varchar(512) NOT NULL,
 PRIMARY KEY (`fin_id`),
 KEY `fin_name` (`fin_name`(200))
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8

The second table:

Code:

| fitem_1 | CREATE TABLE `fitem_1` (
 `fi_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 ......
 `fi_name_id` int(10) unsigned NOT NULL,
 `fi_name_inner_id` int(10) unsigned DEFAULT NULL,
........
 `fi_credit` decimal(11,2) unsigned NOT NULL,
 PRIMARY KEY (`fi_id`),
.......
 KEY `fitem_1_ibfk_4` (`fi_name_id`),
 KEY `fitem_1_ibfk_6` (`fi_name_inner_id`),
 CONSTRAINT `fitem_1_ibfk_4` FOREIGN KEY (`fi_name_id`) REFERENCES `fitem_name_1` (`fin_id`),
 CONSTRAINT `fitem_1_ibfk_6` FOREIGN KEY (`fi_name_inner_id`) REFERENCES `fitem_name_inner_1` (`fini_id`)
) ENGINE=InnoDB AUTO_INCREMENT=134 DEFAULT CHARSET=utf8 |

Vary thanks for your help, but as I said I have found the solution. Just delete "orphan" rows in the first table on each invoking delete() method.