Re: Same record, different blocks

Hi Michael,
Don't do either.
[Quoted] Make one block with multi record view. The summary has a display number of 0 (the default, follows the block definition) and the detail columns has a display number of 1. The coordination then happens totally automatic ... when focus is moved in the summary list, the details automaticly shows the detail values of that current record.

I think this is part of the demos to Forms .....

• Peter H. Larsen

Michael Toomey wrote:
>
> 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

-- 

Peter H. Larsen, Oracle and Applications specialist
Dynamic Resources Inc, Alexandria
Email: plarsen_at_dc.dynares.com
(please remove the nospam from the header when replying to this email)

The above views are my own and does not reflect the views of my
employer.