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 browseNow, 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 browseThanks.