Dave,
I think I might have figured out the first error. I noticed that the bitchID was changed to femaleID down the list.
But now it gives me an error of duplicate key name "fk"
So I'm guessing you meant for me to replace some of this stuff with my names and I just don't know enough yet to see that. Sorry for the lack of experience here.
TroyD