I tried doing in the Data Environment arena.. It doesn't work..

For example,

Lets put some data in :

Org Table: Orgid, Orgnm
Enroll Table: Orgid, Personid
Person Table: Personid, Name

Org Table:

G1 - Grade One
G2 - Grade Two
G3 - Grade Three

Enroll

P1 - G1
P2 - G2
P2 - G3

Person
P1 - Greg
P2 - Fred

When I just join Person to Enroll for Greg, I get

P1 - G1 (which is correct)

and for Fred
P2 - G2
P3 - G3 (which is correct as well)

but when I add the Org to get the description to the DE, I get

P1 - G1 - Grade One
P1 - G2 - Grade Two
P1 - G3 - Grade Three (which retrieves all rows from Org table, which is incorrect)


So I am still not sure what I am doing wrong in this case to not be able to pull the specific description (Not all descriptions) from the third table.

Thanks
Greg