Information générale
Catégorie:
Gestionnaire d'écran & Écrans
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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement