469,645 Members | 1,262 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,645 developers. It's quick & easy.

Lookup/Update Query

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
1 1621
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.

Similar topics

3 posts views Thread by my-wings | last post: by
10 posts views Thread by Razvan Surdulescu | last post: by
1 post views Thread by sierra467 | last post: by
1 post views Thread by paulquinlan100 | last post: by
reply views Thread by =?Utf-8?B?RU1hbm5pbmc=?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.