I recently redid my schema using innoDB and created a bunch of foreign key constraints (the database is storing some loan application data). Basically, it's set up so that when an entry from the application table is removed, all the records from the other tables pointing to it are also removed.

However, I have a couple tables I can't seem to get some kind of constraint working with them. Here is the schema for the two tables:

Code:
CREATE TABLE `secured_credit` (
  `personal_id` int(10) unsigned NOT NULL default '0',
  `property_description` varchar(255) NOT NULL default '',
  `spouse` varchar(100) NOT NULL default '',
  `coowner_1` int(10) unsigned default NULL,
  `coowner_2` int(10) unsigned default NULL,
  `coowner_3` int(10) unsigned default NULL,
  `coowner_4` int(10) unsigned default NULL,
  `coowner_5` int(10) unsigned default NULL,
  PRIMARY KEY  (`personal_id`),
  KEY `personal_id` (`personal_id`).
  FOREIGN KEY (`personal_id`) REFERENCES `personal_information` (`personal_id`) ON DELETE CASCADE
) TYPE=InnoDB;

CREATE TABLE `secured_property_coowners` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `fname` varchar(30) default NULL,
  `lname` varchar(30) default NULL,
  `street` varchar(40) default NULL,
  `city` varchar(30) default NULL,
  `state` varchar(15) default NULL,
  `zip` varchar(20) default NULL,
  PRIMARY KEY  (`id`),
  KEY `id` (`id`)
) TYPE=InnoDB;
Basically, each coowner column in the secured_credit table references a row in the secured_property_coowners. How can I set this up so that when an entry in secured_credit is deleted, any of the entries referenced in the other table are removed?

Thanks.