Complicated query?

[Therese]

I want to build a query for a report consisting of the pedigree of a dog. I have two tables set up as such:

tbldogname:
nameid
dogname
dogdob
dogsex
breederID
(lookup field from breeder table)

tblpedigree:
pedigreeid
nameid (look up field from dogname table)
dogmom (look up field from dogname table)
dogdad (look up field from dogname table)

I would like to display all the info from tbldogname for each dog in the pedigree. However, I think in the pedigree table I shouldn't need more than mom and dad because after that it gets to be rundant typing right, assuming mom and dad are in the tbldogname andhave a mom and dad, etc..? I would like the report to display maybe five generations.

Do I need to structure the tables differently? I can't seem to set up the query to get past the parents of the dog in question. Does this make any sense??????

Thanks in advance.

P.S. I tried subdatasheets and other links, but can't seem to find the one that works.

 

[raskew]

Therese -

Take a look at Allen Browne's solution to the pedigree problem.

HTH -

Bob

 

[Therese]

Thank you!!!