Dear All Experts
I have form based on 3 table with master detail relation (Form 10g)
let us consider situation
form has data block A as master B detail relation with A having multi record say 5 & C with detail relation with A & B
as tabular form display records say 5
now when user enters data on Block B say 4 records some of item fields should get copied to block C respectively.
e.g
block B
item1 item2 item3 item4 item5
record1 a 1 10 0 10
record2 b 2 50 2 100
record3 c 3 100 10 1000
record4 d 4 50 50 2500
I want to copy & display above record to block C as follows
item2 item5
rec1 1 10
rec2 2 100
rec3 3 1000
rec4 4 2500
How to achive this before commit?