Hi Mel,

try this:

FROM FORCE appdata!Ssperson INNER JOIN appdata!Ssmoney ;
ON    m.cIsGrouped AND Ssperson.familyid=Ssmoney.familyid 
  OR !m.cIsGrouped AND Ssperson.personid=Ssmoney.personid

AND

FROM FORCE appdata!Ssmoney INNER JOIN appdata!Ssperson ;
ON    m.cIsGrouped AND Ssperson.familyid=Ssmoney.familyid 
  OR !m.cIsGrouped AND Ssperson.personid=Ssmoney.personid

Can you post the RECCOUNT() of the source and result tables.