How have you currently set up your tables?
What have you tried that didn't work?
Here is one version I tried to use (see attached gif). Thank you.
What does "mating cage #" identify?
I don't know your lab procedures but identifying the cage would not seem to identify a specific mouse or even a pair of mice as the mice in a given cage would seem to be something that would change as you move your specimens around and pair them with different other mice etc.
Assuming that you aren't doing something unusual genetically, a given mouse would have only two parents. Thus, this relationship would seem to make sense for tracking parentage:
SNGE Mice|Father------<SNGE Mice>------SNGE Mice|Mother
SNGE Mice|Father::__pkMouseID = SNGE Mice::_fkFatherID
SNGE Mice|Mother::__pkMouseID = SNGE Mice::_fkMotherID
And all three entities here are Tutorial: What are Table Occurrences? of the same data source table.
For an explanation of the notation that I am using, see the first post of: Common Forum Relationship and Field Notations Explained
Thanks- I'll take a look at your suggestions. As for the mating cage #, that identifies the cage that a mouse was born in. That remains constant and allows one to click in a mouse's record and then activate a script to go to its parents' breeding record. That is working, at least! That is going back in time, so to speak. Now, I want to go forward to the breeding cage it gets set up in.
. As for the mating cage #, that identifies the cage that a mouse was born in.
Yes, but unless you have mice that give birth to single mouse litters, it does not identify a single mouse.
But since all mice in a litter will have the same parents unless you permit multiple males, it could be used to link a litter to their parents.
SNGE Mice::_fkMatingCageID = MatingCages::__pkMatingCageID
MatingCages::_fkFatherID = SNGE Mice|Father
MatingCages::_fkMotherID = SNGE Mice|Mother
Sorry for not making the mating cage info clear. The relationship allows going from any of the offspring back to their single originating parent's mating cage. It does "link the litter to their parents." As I mentioned, this part works ☺
But what I have just posted previously links a specific mouse to its parents via the mating cage record. SNGE Mice, SNGE Mice|Father and SNGE Mice|Mother all have the same data source table.
Yes, but now I'm trying to link to the mating cage that is eventually created when a mouse is paired with a mouse of the opposite sex. So, either the male or female mouse could point to this new mating cage where they are listed as father and mother for their offspring (or offspring to be).
I'm sorry but I don't see the problem you see with that. Can you explain where this breaks down for you?