Here is an example of a SHAPE command that returns the qualifications records for all of the people

SHAPE { SELECT * FROM DT_PERSON }

APPEND({SELECT * FROM DT_QUALIFICATION} RELATE Person_ID TO Person_ID) AS ChildRS

I can append a field to the parent set indicating the number of qualifications for each person using:

SHAPE { SELECT * FROM DT_PERSON }

APPEND({SELECT * FROM DT_QUALIFICATION} RELATE Person_ID TO Person_ID) AS ChildRS, COUNT(ChildRS.Ndx) AS ChildRS_Count

However I cannot seem to figure out where to put the WHERE clause to restrict the parent rows returned, for example, to only include people who have at least one qualification.

I would have thought this would have been a fairly common thing to want to do but i have yet to find any examples of whether it is even possible

Cheers, Dave