>SELECT auth.id,auth.organization FROM auth where auth.authtype = authtype.authtype INTO CURSOR temp
>
>This is what I have as of now in a listbox. I need help with how to link the auth.id to person.id to display person.name.
>
>Chuck

Chuck,

*listbox.init
lcSQL = 'select person.Name, auth.Organization, auth.id'+ ;
 ' from auth join person on auth.id = person.id'+ ;
 ' where auth.authtype = authtype.authtype'+;
 ' into cursor temp'
with this
 .Columncount = 3
 .BoundColumn = 3
 .Bound = .t.
 .Columnwidths ='100,100,100'
 .RowsourceType = 3
 .RowSource = lcSQL
endwith

Cetin