>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

Chuck,

Each solution depends on situation :) Did you see Rich's answer? If you did seek first, you can use info from the record, e.g. Person.Name, Person.Age, etc., but don't include Person table in your SQL.