>The first CASE works perfectly:
>

>CASE m.pick='Org'
>	=SEEK(ThisForm.List1.List(ThisForm.List1.ListIndex),"org","main")
>	SELECT person.name, auth.organization, auth.authtype, auth.effective, auth.end ;
>		FROM auth, person ;
>		WHERE auth.organization=org.organization ;
>		AND person.id=auth.id ;
>		INTO CURSOR temp
>browse

>
>Now, the trouble is this next CASE. Even though this CASE is based on m.pick='Name', it will still be same as for m.pick='Person ID' (I could put them together into one CASE, but that's not the issue). What I like to do is list ALL authorizations (auth.authtype) this person have (person.id). In other words, I need to know what this one person.id have in the auth table equaling matching person.id=auth.id.
>

>CASE m.pick='Name'
>	=SEEK(ThisForm.List1.List(ThisForm.List1.ListIndex),"person","main")
>	SELECT person.name, auth.organization, auth.authtype, auth.effective, auth.end ;
>		FROM person, auth ;
>		WHERE auth.id=person.id ;
>		INTO CURSOR temp
>browse

>
>Thanks.
>
>Chuck



You are including the person table in your query to get the person's name ( I guess) but this is giving you a complete join. Try the excluding the person table from your query like the following.

CASE m.pick='Name'
	=SEEK(ThisForm.List1.List(ThisForm.List1.ListIndex),"person","main")
	SELECT  auth.organization, auth.authtype, auth.effective, auth.end ;
		FROM auth ;
		WHERE auth.id=person.id ;
		INTO CURSOR temp
browse

Alek