Re: Forms Question - Looking up details

From: Robin Quasebarth <quasebarth_robin_r_at_solarturbines.com>
Date: 2000/05/10
Message-ID: <3919BC34.A547A547_at_solarturbines.com>#1/1


One nice trick to get around navigational restrictions on a trigger is to create a timer instead of your ENTER_QUERY/EXECUTE_QUERY. Then have a WHEN-TIMER-EXPIRED do your query. rq

Paul Cullen wrote:
>
> I have a form (created in version 4.5) which has a master/detail join
> between 2 base table blocks. All works OK, querying, performing the
> master/detail look-up etc.
>
> I have created a list of values (LOV) on one field (CODE). This also works
> OK as far as the LOV is concerned, and returns a value for the CODE field as
> expected and populates the code field on the form.
>
> What I want to do now is to populate all relevant details in the master
> block based on the CODE selected and then go off and get items for the
> detail block.
>
> I have tried to put in ENTER_QUERY/EXECUTE_QUERY calls in the POST-TEXT-ITEM
> trigger for the CODE field but get restricted trigger messages all over the
> place.
>
> Does anybody have a slick solution for the above?
>
> Thank-you in advance.
>
> Paul.
Received on Wed May 10 2000 - 00:00:00 CEST

Original text of this message