Relationship question

Discussion created by chronister on Apr 26, 2014
Latest reply on Apr 27, 2014 by chronister

Hello all,


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?