AnsweredAssumed Answered

One field to either of two fields in another table's record

Question asked by ScottYoung on Oct 21, 2013
Latest reply on Oct 21, 2013 by philmodjunk

Title

One field to either of two fields in another table's record

Post

     I have a database that follows animal breedings. Currently, I have a relationship established such that selecting an animal's parent's cage # in table 1 opens the record in table 2 that shows the parent's mating information. I can't seem to establish a relationship such that selecting the animal's ID in table 1 opens the record in table 2 showing the information about this particular animal's mating information. The animal could be a male or a female so I tried to establish the relationship to table 2 to either that record's male ID or female ID. Any advice would be greatly appreciated!

Outcomes