I cannot find anything to help me with this so hopefully it has not been answered already.
I have a single table:
Registration Number
Name
Sire
Dam
The sire and dam field are the registration number for the sire and dam. I can get the numbers, but how do I get the name field for those...