You're right, it should be

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.
>
>Thanks again Sergey!