I'm a newbie to Base, so go easy!
I have a database of dogs in which every animal has an ID we'll call DogID. Each record has a Dam ID and a Sire ID, which each relate to a another record (DogID) in the same table.
Is it possible to produce a five generation pedigree as a report from one DogID?