Re: Forms 5.0 blocks

Lets say that the pick list is called L_FILTER, and the column you would like to filter in the 2nd block is called DEPTNO. Here is the code that needs to be placed in the Default Where clause of the 2nd block:

DEPTNO = NVL(:L_FILTER,DEPTNO) In the When-List-Changed trigger of the Pick-List, re-query the 2nd block.

The NVL allows you to leave this code in the Default Where clause property of the block when the user does not want to filter on anything.

Joe Strano
Dulcian, Inc.

Frank W Phillips JR <FWP_at_vpha.ufl.edu> wrote in article <350ECFF9.5D03FC6C_at_vpha.ufl.edu>...
> I am attempting to create a canvas that contains two blocks. The
> problem, block 1 is a control block; block 2 is a detail block based on
> the results of a pick list in block 1. I can not create a master/detail
> relationship. I do not wish to make block 1 a database block. Is it
> possible to populate the “detail” block based on a control item from
> another block? If so, how?
>
> I want to keep block 1 a control block so no new records can be inserted
> and existing record are not updated. I also want to avoid fighting
> modes; I don’t want the user to have to enter query mode to select the
> detail block to work on. The control block is a set of pick list that
> brings them to a small set of detail records. Thanks for the help…
>
>
>
Received on Tue Mar 17 1998 - 00:00:00 CET