FAMILY TREE

[Andy]

Hi;

Created something like a "Family Tree" database. Getting in-correct
placement of data displayed in the report.

Tracking Ancestor/Predecessors, Education and Career.

Have:
tblMain, (Name/Address/Phone)
tblEducation (High School/College)
tblCareer (Current Job/First Job)

Relationship is one to many to tblmain using tblMainID.

Created qryCombined.and based the report on it.

Name/Address/Phone controls are in Report Header.

High School
College
Current Job

Display correctly if the Current Job was also the First job.

The problem arises when the person worked at two different jobs.

High School
Current Job
College
First Job.

If Hide Duplicates = False it shows two of each. Tried Hide Duplicates =
True, and CanShrink = True

Tried Grouping Education (w/wo Headers/Footers). Tried Grouping Career
(w/wo Headers/Footers)

Sorting. Whole Group. PreFix. All in Detail. None in Detail. In Header.
In Footer. A dozen more.

What's wrong?

Andy

 

[Fons Ponsioen]

It appears the problem is related to the sort order of
your subreport.
Is it possible to combine the data from the jobs and
education so as to allow sorting by date or by
Education/Job and secondary by date.
It also could be a problem witht he rlationship, if not
both are directly related back to the main, it could
create a many to many relationship with the applicable
replications.
Maybe with more information I could help, and be more
specific.
Fons

 

[Andy]

Fons:

In response to your post:

It appears the problem is related to the sort order of your subreport.
DO I NEED A SUB REPORT? IS THAT THE WAY IT'S DONE?

Is it possible to combine the data from the jobs and education so as to
allow sorting by date or by
Education/Job and secondary by date.
NO DATE IS ENTERED FOR EITHER JOBS OR EDUCATION. JOBS AND EDUCATION EACH
NEED TO HAVE IT'S OWN FIELD.

It also could be a problem witht he rlationship, if not both are directly
related back to the main, it could
create a many to many relationship with the applicable replications.
THE RELATIONSHIP IN THE QUERY IS:
"INCLUDE ALL RECORDS FROM ">tblMain" , (Name/Address/Phone)" AND ONLY THOSE
RECORDS FROM ">tblEducation (High School/College) OR >tblCareer (Current
Job/First Job) WHERE THE JOINED FIELDS ARE EQUAL"

Maybe with more information I could help, and be more specific.

FONS; THANK YOU FOR YOUR POST. HELP THE ABOVE HELPS.

WAS THINKING, HAVE YOU HEARD OF MICROSOFT HAVING A "FAMILY TREE" TEMPLATE
FOR ACCESS?

ANDY