Re: Forms Question - Looking up details

There are two possible scenarios I see:
1st: you are in enter-query mode. Then you have to do all population of your master block items in the POST-QUERY Trigger. This fires automatically when you hit the execute query key / button. Then the detail block will automatically processed by the forms logic and the corresponding rows will be fetched. Further (non database field information) can
be retrieved for the detail block with the POST-QUERY Trigger on the detail block level.

2nd: You are in insert/update mode:
Fill in the corresponding values using the when-validate-item trigger on the field that is populated by the LOV.
Then do a go_block('detail_block'); do_key('execute_query'); That should do the trick.

Hope this helps.
Andy

Paul Cullen schrieb:

> 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 Thu May 11 2000 - 00:00:00 CEST