I have a fairly simple database (SQL) that is used to track cattle inventory. Each cow is added to a table called Stock. The main form then shows all the information from the Stock table. The 3 fields that are important for my question are ID#, and the Dam and Sire fields. On that main form is a subform that shows the offspring of each cow. Currently it works fine for showing all the offspring for all females because the the master field “ID” is linked to slave field “Dam”. This correctly displays all calves that have the ID number in the Dam field.
Is there a way to make it so the Sire field can also be linked to the same ID field. This way offspring will correctly show under records for Male cattle as well.
I tried listing both options: “Dam”;“Sire” for “ID”;“ID” but this made it so that no results showed for neither males nor females.
Any suggestions are appreciated.