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.