Connecting Tech Pros Worldwide Forums | Help | Site Map

Lookup/Update Query

Lumpierbritches
Guest
 
Posts: n/a
#1: Nov 12 '05
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
Guest
 
Posts: n/a
#2: Nov 12 '05

re: Lookup/Update Query


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.

Closed Thread