Re: switching data blocks based on subtype

In article <90q53k$4a$1_at_nnrp1.deja.com>,   bs7259_at_my-deja.com wrote:
> Does anyone know how to switch a detail list in a
> developer form? Specifically, we have a product
> table with general product information. Then we
> have subtype tables for each specific product
> type. A product is an audio, video, merchandise,
> or game, and we want a specific details data
> block to appear whenever a type is selected from
> a drop down list. Is there any way to write a
> trigger that will switch the data block in a
> frame?
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sure you can.

You need to build all the block variations on the same page and area and make the blocks invisible. The detail block should be the same size in order to stop bleed through from the previously displayed block.

Within the parent block and the specific record, you would go to the appropriate block, make it visible and query the results.

You can look at the default code for populating a detail block and modify it there.

The Forms tool is a 4GL.

--
Michael Krolewski
Rosetta Inpharmatics
mkrolewski_at_rosetta.org
              Ususual disclaimers


Sent via Deja.com http://www.deja.com/
Before you buy.