Lumpierbritches wrote:
[color=blue]
> Thank you in advance for any and all assistance, it is GREATLY appreciated.
>
> I have a Query that shows an AnimalName and Damof and Sireof. When I click on
> the unbound lookup combobox, I can populate the Dam and Sire of the Animal in
> question. What I would like to be able to do is also populate each successive
> Dam and Sire in the family line of each animal, so long as that information is
> available.
>
> AnimalName: XYZMaleDog
> Dam: ABCFemaleDog
> Sire: MNOMaleDog
>
> Then I would like the Dam and Sire of ABCFemaleDog and Dam and Sire of
> MNOMaleDog to populate the next line for relationships. I know this is done
> more than likely in a query, but I'm stumped.
>
> Michael[/color]
Since you haven't received a response....goto
http://groups.google.com
select Advanced Search and in the words to look for enter
geneology
ancestors
etc...
and in the groups to search enter
*Access*
There have been discussions of this in the past.