>INNER JOIN appdata!Ssmoney ; >ON m.cIsGrouped AND Ssperson.familyid=Ssmoney.familyid > OR !m.cIsGrouped AND Ssperson.personid=Ssmoney.personid >>The above one takes 50 seconds.
>INNER JOIN appdata!Ssmoney ; >ON IIF(m.cIsGrouped,Ssperson.familyid,Ssperson.personid) = > IIF(m.cIsGrouped,Ssmoney.familyid,Ssmoney.personid) >>This one is instantanious (less than a second). Just very interesting how this can be such a difference.