One field to either of two fields in another table's record
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!