Lookup/Update Query

[Lumpierbritches]

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

[Salad]

Lumpierbritches wrote:

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

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.