Jump to content

Self join set-up question

Recommended Posts

Hi, I have attached a mock-up database and schematic to explain this. Basically, I have a list of animals with lots of vet history. One aspect we want to track is the breeding history for each animal. Each female can be a Sam (mother), each male a Sire (father) and all animals could be Offspring.  I would like to look at the record for each Dam and Sire and see their offspring, as well as looking at each Offspring and seeing their parents. This could, of course, end up multi-generational where an individual animal is both a parent (Dam or Sire) and an Offspring.

Each animal has a unique ID. I have tried creating a Dam ID for each Dam, a Sire ID for each Sire and an Offspring ID for each offspring and relating them in joining tables - one for Sires and one for Dams.

So far, I can see the parents of each Offspring, but not the Offspring that belong to each Dam and/or Sire.  I'm stumped as to how to further set up relationships and portals for this.


Animal breeding records.fmp12 Breeding.pptx

Link to post
Share on other sites

See if attached sketch can work for you. Note that it needs more work - for example, the choice of parents should be limited by sex.

See also this thread about sire, dam and herd: 





Edited by comment
Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.