Re: Newbie Forms 4.5, LOV, and displays

Hi Michael!

"Michael McGrath" <mcgrathm_at_tcd.ie> wrote in message news:3A9D094E.4336F817_at_tcd.ie...
> Hi,
>
> I've searched documentation and text books without success to try
> and do the following simple thing.
>
> When the form retrieves data some of the fields might be codes
> e.g. table orders might have field item codes that refer to
> descriptions of the items in table item.
>
> I simply want to be able to define a non table text item that
> displays the item description for an existing item code.
>
> This should change when the user selects a new item code from a
> LOV.
> The question really is what trigger should be used in such a
> case.
>
> I'm sure this is very easy but I just cannot get this right.
>

I think there is no need to use any trigger if you want to populate non table text item from LOV.
1. create LOV based on query that just retrieve item code and description from description table.
2. go to LOV properties, Column Mapping and assign Column Names to Return Items where Return
Items should be in format 'block_name.field_name' 3. go to block with item codes, select this field, open properties and then assign in
Miscellaneous section LOV property to your newly create LOV.

Andrew Velichko
Brainbench MVP for Oracle Developer 2000 http://www.brainbench.com