SELECT Str(id) + MAX(TTOC(effective_date, 1)) AS id_maxdt; FROM address_tbl ; GROUP BY id ; INTO CURSOR crsAddr SELECT Str(id) + MAX(TTOC(effective_date, 1)) AS id_maxdt ; FROM name_tbl ; GROUP BY id ; INTO CURSOR crsName>Arggggg... you are right, I was hoping to stay away from a multiple pass REQUERY() solution. Your first two SQL statements require a GROUP BY clause; but other than that, the logic shines through.