I am creating an app that tracks the livestock on our farm. I currently have the sheep separated into 3 google sheets/tables; Ewe, Ram, Lamb. I did this initially so that I could track breeding lineage. So an Ewe can have a REF to a lamb and vice versa. The problem i am running into is that a lamb eventually becomes a Ewe or Ram, so I am trying to rethink my structure so that I have a SHEEP table and then a dropdown that allows the user to select the animal type. I am wondering how I can still track the breeding lineage this way?