multiple records contingency report

[TLJ]

I know this should be simple for some of you that I read posts from.

I need some help with gathering info from a multiple records of the same fields of info for a pedigree report. all animals are put in the same table. I want to be able to see and print lineage.

table has these fields

name (primary key)
dob
ear#
weight
color
mother
father

I understand how to get these on a report from a query.

What I don't know how to do is add mother and father info from their records to show on the report.
i want to ask for "name"
and produce grandfather name
ear #

name father's name
ear# ear# grandmohter name
color color ear#
weight weight

mother's name grandfather name
ear# ear#
color
weight grandmother name
ear#
I don't know how to write code to produce mother and fathers info from the text boxes of record1 from their individual records of say record 6 and 8 and then their mother and father's info from record 9 and 14 etc...

 

[Pat Hartman]

Did nelig ever send you his cat pedigree db?

You might look into the treeview control. It is designed to look at hierarchially related data. You will probably have to look at the father parentage separate from the mother parentage.

If you want to write your own queries, it gets pretty complicated. You need to include a separate instance of your table in the query for each parent and each generation. You join them
motherID or fatherID to the ID of the next generation, etc. Use left joins so that you'll still get results even if your table does not contain any more generations.

 

[TLJ]

Did nelig ever send you his cat pedigree db?

I have not gotten a reply yet.

I will look into the treeview control as well as your other suggestions. Thanks for your response. I have the time to play with this. Thank you for your ideas it is a start.