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