Re: Forms 4.5 Query ???

From: <afischer_at_ea.com>
Date: 1996/02/26
Message-ID: <4gt6j8$min_at_viper.ea.com>#1/1


Sean Kubovcik <rbtkubo1_at_ix.netcom.com> wrote:
>I have a form that has master/detail relationship with the master on one canvas and the
>detail on another. I want to be able to query on the detail and go_block(master)via double
>clicking on the specific detail record's key and have the master canvas populated and
>queried on the selected detail record. I tried to have a double click event (on the detail
>record key) with:
>
> go_block('master');
> enter_query;
> :master_field := :detail_field; (record to query on)
> :execute_query;
>
>This would not work. I even tried to put the assignment in a pre_query trigger of the
>master block, but, that fails.
>
>What I am asking is how do I go to a block or form, initiate a query, assign data to a field
>and execute the query from another block or form?
>
>I would appreciate any input. Thanks in advance.
>
>
>Sean
>
>rbtkubo1_at_ix.netcom.com

You might try going to master, then setting that block's default WHERE clause (set block property) with the appropriate value(s), then execute the query. Hope that helps. Received on Mon Feb 26 1996 - 00:00:00 CET

Original text of this message