Re: Question about LOV in Forms 6.0

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

On Fri, 01 Sep 2000 06:16:22 GMT, Marc Billiet <someone.overthere_at_living_in.be> wrote:

>Create a KEY-LISTVAL trigger on the master-item or master-block, and
>write :
>
>List_Values; -- or Show_Lov(...)
>-- eventually populate all the fields, if not done by the LOV
>-- e.g. by executing Do_Key('EXECUTE-QUERY');
>-- and now populate the detail block:
>Go_Block('Detail');
>Do_Key('EXECUTE-QUERY');
>
>This should work if your master-block is in enter-query mode or if your
>master-block is just a control-block (no base-table). Otherwise forms
>will think you are adding a new row in the master-table.
>
>Marc
>>>>>>>>>>>>>>>>>>> Oorspronkelijk bericht <<<<<<<<<<<<<<<<<<
>
>Op 2000-08-31, 23:33:34, schreef me_at_me.com (¥ Scott ¥) over het thema
>Question about LOV in Forms 6.0:
>
>
>> Hi,
 

>> This may be stupid, but I just don't know how to do this. I have a
>> form with master-detail blocks. I have a LOV attatched to the first
>> item in the Master block. When the user selects from the LOV, I
>> populate all the fields of the Master block.
 

>> Now I just want to execute query. Just as if the user hits that
>> button. I tried many different triggers on the items and the master
>> block itself (when-new-item, when-new-record, post-change, post-query,
>> etc).
 

>> Anybody know what I need?
 

>> Thanks,
>> Scott
Received on Fri Sep 01 2000 - 17:20:28 CEST