I have a requirement as follows

I have 3 objects

Object 1 and Object 3 are Connected through a Junction Object Object 2

Obj1 Record Obj2 Record Obj3 Record Rate 1234 456 1111 $10 5555 678 1111 $40

I need to print as 1234 has the rate $10 and 5555 has the rate $40 but there is no direct relation between object 1 and object 3

I tried storing the Obj1 Record Id in Obj 3 and tried to use in the page block table but it is getting overwritten.

please help

Thanks in advance

I have 3 objects

Object 1 and Object 3 are Connected through a Junction Object Object 2

Obj1 Record                      Obj2 Record                 Obj3 Record  Rate
1234                             456                         1111          $10
5555                             678                         1111          $40 

I need to print as 1234 has the rate $10 and 5555 has the rate $40 but there is no direct relation between object 1 and object 3

I tried storing the Obj1 Record Id in Obj 3 and tried to use in the page block table but it is getting overwritten.