Re: Forms 5.0 blocks
Date: 1998/03/18
Message-ID: <6enml3$ir7_at_info.csufresno.edu>#1/1
In article <350ECFF9.5D03FC6C_at_vpha.ufl.edu>,
Frank W Phillips JR <FWP_at_vpha.ufl.edu> wrote:
> 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
We have a bunch of forms that work similarly to what you want. Your form can automatically populate the detail block when the user selects a value from the pick-list.
To do this, keep an "old value" of the previously selected pick-list value, and in a when-list-changed trigger, if the present value is different from the old value, do two commands: Go_Block('Detail_Blk'); and then Execute_Query;
In the detail block, set the where-clause to: key_value = :Cntrl_Blk.Pick_list_item
Regards,
Steve Cosner
http://members.aol.com/stevec5088
Downloadable utility form -- Display and update any table. Received on Wed Mar 18 1998 - 00:00:00 CET