Troy,
I would suggest you need to create two more tables, the first one which would be managed by a normal DataAssist form like so:
DROP TABLE IF EXISTS `tbl_breedingschedule`;
CREATE TABLE `tbl_breedingschedule` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',
`maleID` bigint(20) unsigned DEFAULT NULL COMMENT 'Foreign Key tblMales',
`bitchID` bigint(20) unsigned DEFAULT NULL COMMENT 'Foreign Key tblFemales',
`dateMated` date DEFAULT NULL COMMENT 'Date Mated use <?php echo date("Y-m-d",time()); ?> or a calendar popup',
`dateDue` date DEFAULT NULL COMMENT 'Date Due use <?php echo date("Y-m-d",time()); ?> or a calendar popup',
PRIMARY KEY (`id`),
KEY `fk` (`maleID`),
KEY `fk` (`femaleID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
and the second one which would be managed by the Manage Relational Table Server Behaviour which would look like so:
DROP TABLE IF EXISTS `tbl_breedingspuppies`;
CREATE TABLE `tbl_breedingpuppies` (
`breedingScheduleID` bigint(20) unsigned DEFAULT NULL COMMENT 'Foreign Key tbl_breedingschedule',
`puppiesID` bigint(20) unsigned DEFAULT NULL COMMENT 'Foreign Key tblPuppies',
PRIMARY KEY (`breedingScheduleID`,`puppiesID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
Does that help ?
