View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Relational Table or something else?

Thread began 10/18/2009 1:42 am by troyd | Last modified 10/22/2009 4:26 pm by troyd | 2476 views | 16 replies



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.


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` )

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.


Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question





Ease of use


security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...