sudha

Join table concept

Discussion created by sudha on Jan 7, 2016
Latest reply on Jan 7, 2016 by beverly

Hi all,

 

Please confirm my understanding about join table concept:

 

Consider three tables Parent A,Join A,parent B

 

Parent A is related to Join A using Id1

Join A is related to parent B using Id2

 

In the layout, the main table associated is Parent A

If I want to fetch related records from parent B, even though the relationship is not established directly, as the join has the unique combination of Id 1 and Id 2 for each record, Using these key values, related values will be fetched from parent B using the portal tool.

 

Thanks

Outcomes