How to use a query field as a parameter to requery DB

[Guest]

Table fields = Name, Sire, Dam. I want to set up a query so that you enter
the Name of the animal and the query picks up the rest of the pedigree using
Sire as Name and Dam as Name automatically to generate the rest of the fields
(Grandsire and Granddam) for the original Sire and Dam

 

[Van T. Dinh]

Is there any limit to the number of generations you need to go back ( great
great great ... grand ...???).

I guess you should have a look at Allen Browne's example:

http://www.allenbrowne.com.au/ser-06.html

 

[Guest]

Thanks, exactly what I needed

Is there any limit to the number of generations you need to go back ( great
great great ... grand ...???).

I guess you should have a look at Allen Browne's example:

http://www.allenbrowne.com.au/ser-06.html

 

[Van T. Dinh]

You're welcome ... Glad to help ...