need a continues form

[FilemakerPro_Developer]

I tried doing a cross tab query and that doesn't seem to work. I don't need
to count anything or have headers anywhere but on the first line. I just
want to list all 4 fields on the same line in a continues form.
For example
case number, partyType1, PeopleType1, Name; partyType2, People Type1, Name;
partyType1, People Type2,name; PartyType2, PeopleType 2, name

This is the line I want it all on one line with all 4 fields across the line.

Like I said before the SQL query works but puts all the fields in 4 records
even though they are the same case record.

SELECT tblEvaluations.[Name Last], tblCases.CaseID, tblCases.[Case Number],
tblEvaluations.[Name First], tblEvaluations.[Name Last],
tblEvaluations.PartyTypeID, tblEvaluations.PeopleTypeID
FROM tblCases INNER JOIN tblEvaluations ON tblCases.CaseID =
tblEvaluations.CaseID
WHERE (((tblCases.CaseID)=[Forms]![frmCases]![CaseID]) AND ((tblCases.[Case
Number])=[Forms]![frmCases]![CaseID]) AND ((tblEvaluations.PartyTypeID)=1)
AND ((tblEvaluations.PeopleTypeID)=1)) OR (((tblEvaluations.PartyTypeID)=1)
AND ((tblEvaluations.PeopleTypeID)=2)) OR (((tblEvaluations.PartyTypeID)=2)
AND ((tblEvaluations.PeopleTypeID)=1)) OR (((tblEvaluations.PartyTypeID)=2)
AND ((tblEvaluations.PeopleTypeID)=2));


I think the SQL query needs to change to be a self-join on the party type
and people type or there needs to be a composite key.

thanks,