Dave,
This helps a lot and thanks for taking the time to do that. However, it's something I'm still learning so I believe these two tables are a bit foreign to me until I figure out what to do with them.
Also, I got an error while trying to create the first table. The second table created just fine.
Here's my error in phpMyAdmin.
Error
SQL query:
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
MySQL said: Documentation
#1072 - Key column 'femaleID' doesn't exist in table
Maybe I did something wrong when creating it. I just copied and pasted your code into the SQL.
A couple of questions. Will these tables work with the three I already have (once I update the column names to match), or is one of them a suggested replacement for the two I have for Male and Female?
I still need to understand the foreign key. Do I need to create a new column in my current tables to include a foreign key. And if so, how do I get them to match. I'm totally lost here. Once I do something it clicks in my head but I've yet to find a real basic example of this. I have looked through all my WA solutions such as PowerStore but I don't see anything in there.
Lastly, what do the double underlines mean in the table view of phpMyAdmin? For example, the tbl_breedingschule table has field breedingSchuduleID and puppiesID. They are underlined and then have a dotted underline. What's that telling me?
Thanks for the help. I'll continue reading in the meantime.
TroyD
