Re: Forms Question - Looking up details

If CODE is in the master block, you probably need to move it (or duplicate it) to a control block. After the item is populated from the LOV, go to the master block and do execute_query. The default where clause on the master block needs to reference :control_block.code.

"Paul Cullen" <mail_at_cullenpm.freeserve.co.uk> wrote in message news:8fcbm0$vv4$1_at_news8.svr.pol.co.uk...
> 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