How to join three or more blocks in a form (like master/detail)
975322Nov 20 2012 — edited Nov 20 2012I have four data blocks for four tables, lets call them blocks A, B, C, D
Block A is a master block and block B is a detail block, block B holds a foreign key from block A (ofcourse)
Now when i choose in a query data from block A it lists also data from detail block that is corresponding, but now.....
detail block B also holds another foreign key from block C which takes his key from block D. and
i want to make a form that will, when i query master block A, show some data from block B, C and D that is
corresponding to block A.How do i do that?
i'm using 10g and i am a begginer