yes you would use the id from tbl_breedingschedule as the value for breedingScheduleID in tbl_breedingspuppies
OK. I'm probably over thinking this but I don't want to assume anything.
Do my two main tables tblMales and tblFemales have both an id and a maleID or bitchID?
I'm guess no. But not sure.
I have "id" already on all my tables. Setup as int. auto-increment, primary.
Do I need to add the others or were you referring to the id as maleID and bitchID? Should I just rename my column name from id to maleID?
I ask because I see that tbl_breedingschedule has all, id, maleID and bitchID. Which I assume is because the last two are the FK for the other tables and this table needs it's own id for tbl_breedingpuppies to join with. Is this correct?
Maybe I should map out an image like the one that Office Guy referred me to. It might help me explain what I've done.
(Sam's MySQL in 10 Minutes, book on order).