Re: Display item in master detail block

Add a POST-QUERY trigger to your detail block.

In the trigger write some code that selects the details back for you.

In it's crudest form (i.e. not taking account of performance considerations) this could look something like this..

begin

--
select acct_desc
into :block.disp_item
from details_table
where acct_id = :block.acct_id
--
end;

This will fire for every row in your details block.

--
Regards

Jason

____________________________________________________________________________
__

  Jason Pepper - Enterprise Internet Tools Product Management
____________________________________________________________________________
__

Opinions are mine and do not necessarily reflect those of Oracle Corporation

"GuyGbarnes" <guygbarnes_at_aol.com> wrote in message
news:20000413065143.15566.00000014_at_ng-fo1.aol.com...


>

> Hi Folks,


>

> I have a simple form with two blocks on it,  with a master detail

> relationship between the two.  The detail block displays a number

> of account entries for the master block . On the detail block I

> want to add a display field which will be an account description

> which is held in another table.  How do I go about populating

> the display field programmatically or do I have to add another

> block.

>

> Cheers Guy

>