Same record, different blocks

From: Michael Toomey <michaelt_at_americanrecruitment.com>
Date: Thu, 9 Jul 1998 16:51:34 -0700
Message-ID: <6o3kvf$nf3$1_at_nnrp1.ni.net>

[Quoted] [Quoted] in forms 4.5, what is the best way to do the following:

on the same canvas, i'd like to have two different blocks, with the same base table, displaying the same records. one will display multiple records (summary info) and the other one record (detail info).

as you scroll in the multiple record block, selecting a new record puts the details in the detail-level block.

i have this working fine by defining a relation between the two, with the ROWID being the join criteria. scrolling through the records in the summary displays the same record in the detail.

problem is, i can't modify the data in the detail level, because the record is locked from being in the summary level.

do i need the detail level to be a control block? i definitely prefer for it to be a base-table block, so i can use all the default functionality in forms.

or, do i need to build the summary level block (multiple records) with a pl/sql procedure?

i guess i don't completely understand the way locking works, since i would not be seeing this problem if i had this split into two forms. of course i don't wanna do that either. making the summary-level block "query only" has no effect.

any help?
-mt Received on Fri Jul 10 1998 - 01:51:34 CEST