By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,404 Members | 1,987 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,404 IT Pros & Developers. It's quick & easy.

Lookup/Update Query

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.