Thanks for the image. That does help me because I can now refer to the mapping as I learn and see what I am trying to accomplish.
So a FK can be anything that would be unique in all records? For example, the current tables I have working now all have a MaleID, FemaleID and a PuppyID in their tables. As Dave made use of in the two table examples. So those current columns would act as the FK?
But how do I get the tbl_breedingschedule to insert the number from the male and female table? Do I use Dynamic Dropdowns on the insert form?
And if the MaleID is updated in the tblMale will it be updated in the tbl_breedingschedule? Do I fix the update page to update both tables?