I'll give you a credit for it, even I had little hard time finding out why I kept getting errors, but it was the missing "ID" in the lnPersonID :)

>>CASE m.pick='Name'
>>*	=SEEK(ThisForm.List1.List(ThisForm.List1.ListIndex),"person","main")
>       local lnPersonID
>        lnPerson=int(val(ThisForm.List1.List(ThisForm.List1.ListIndex)))
>        lnName=ThisForm.List1.List(ThisForm.List1.ListIndex,2)
>>	SELECT lnName as PName, auth.organization, auth.authtype, auth.effective, auth.end ;
>>		FROM auth ;
>>		WHERE auth.id=lnPersonID ;
>>		INTO CURSOR curTemp
>>browse

The question still remains how to do this SQL "straight forward" (instead of using the lnName). I did another SQL also with two tables and works. There may come a time where I may need data from three tables where the "lnName" may not be possible.

Chuck