Re: Question about LOV in Forms 6.0

Hi Neville,

Thanks very much for the info. I will give that a try.

Take care,
Scott

On Mon, 4 Sep 2000 13:51:36 +1100, "Neville Sweet" <sweet.neville.nj_at_bhp_xxx_.com.au> wrote:

>Hi Scott,
>
>Instead of the LOV returning values into items in your master block, load
>control block items instead. In a master block Pre-Query trigger, copy the
>control items into your master block items.
>In your code attached to the button press, show the lov and then after
>testing that a value was selected, issue the Execute_Query and let the
>On-Populates do the rest.
>
>¥ Scott ¥ wrote in message <39b0c935.4964514_at_news.ikea.com>...
>>Hi Marc,
>>
>>Thanks for the info. That did not work. My master-detail relations
>>must not be set up correctly. But they do work. I have one master
>>block and it has a base table. Then I have 4 detail blocks. Each with
>>their own base tables.
>>
>>What the user can do now is:
>>There is a button in the master block at the first text box. This is
>>clicked to bring up the LOV. I mapped the LOV to return values to
>>populate all the fields in the master block. All this time, the form
>>is in Enter-Query mode. Then the user hits the Execute Query button
>>(or hits F8 key) and then the details get populated with the
>>On-Populate-Details trigger.
>>
>>What I am looking to do is to duplicate the execute-query action
>>automatically so the user does not have to.
>>
>>Thanks,
>>Scott
>
Received on Mon Sep 11 2000 - 16:28:34 CEST