Duplicate Records in Family Tree Report.

[Andy]

Hi;

Creating a "Family Tree" database report.

3 tables: Personal, Relatives, Military Service. Each contain and related
by "PersonalID" field. 1 to 1 relationship

Created 3 queries based on those tables w/only * in field. Created
qryFamilyTree based on the 3 queries. 1 to 1 relationship
qryPersonal: PersonalID, Name, Education (1 record in this example)
qryMilitary PersonalID, Service: Branch, Rank (2 records)
qryRelatives: PersonalID, Name, Surviving Y/N (3 records)

Query returns 6 records (rows). Each cell is occupied w/data when query is
run.

The report header contains the data from qryPersonal fields. This works
correctly.

Remainder of report is not displaying correctly. Getting:

Abraham Lincoln
One Room School House
Army Captain
Mary N
Tad N
Robert

President Commander in Chief
Mary N
Tad N
Robert

Used Sorting/Grouping to create "Branch" & "Surviving" Headers.

Tried "Whole Group" & "Prefix Characters". Tried it singularly, (only one
occurence of "Whole Group" & "Prefix Characters"), tried dual occurence one
w/footer one w/o.

Report displayed:

Abraham Lincoln
One Room School House
Army Captain
President Commander in Chief
Mary N
Tad N
Robert

Army Captain
President Commander in Chief
Mary N
Tad N
Robert

This is a "simple" Access "Family Tree" database, what am I missing?

Any Ideas?

Andy