I am working on a second project for a local animal shelter. I am building them a management system to keep track of people, animals, adoptions and other stuff.
This one is simple and I wanted to see if I am mis-understanding relationships.
I have 3 tables..... Animals, Breeds Species
They are linked properly as you can see. When an animal is assigned a breed, shouldn't the species be related automatically at that point?
On my animals layout, I want to display the species, but it is not showing up as though it has no relationship.
I understand this setup to give the animals table an inherent relationship to species through the Breeds Table. Right?
If so, then why would species not show on the layout in either an edit box or a label?