>>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 >>browseThe 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.