SELECT auth.id,auth.organization, person.name ;
FROM auth ;
JOIN person on auth.id = person.id ;
WHERE auth.authtype = authtype.authtype ;
INTO CURSOR temp
Should give you the name field in the same cursor.
>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