how to synchronize two block's data.
I have related two blocks. block B and block A are on the same canvas. One block A is based on view, and block B 's data is from block A's post-query trigger.
I want to see when I press each current record indicator for each record in block A, corresponding record in block B will be shown.
Now the problem is I cannot synchronize two block's data. For example, I input an ID in search block to bring up the block A, there are two records. There are also supposed two records in block B. But, in block B, there is only one record, always the last record from the post-query trigger.
Block A
ID DESC
123 ABC
246 HGJ
Block B
ID JOBS
123 ALEX (This line is missing)
246 BILL (only show this line)
I ever debug the post-query trigger and put the message statement to display the ID. The message can pop up both ID 123 and 246
Any ideas how to fix it?
I am using Oracle 8i database and application 11.0.3