Re: Developer/2000 Checkboxes

From: Simon <simon_at_sibass.com>
Date: Fri, 24 Aug 2001 12:36:04 GMT
Message-ID: <3b864a30.0_at_news.cali.co.uk>


"Bruce Panowski" <panowski_at_lanl.gov> wrote:
>We are trying to use checkboxes in the detail blocks of master/detail
>relationships. We want to dynamically create the checkboxes (and checkbox
>prompts) from a table of valid values.
>For example: The master block is ORDER. The detail block is ITEM. There
>are a total of 5 items a person can place on an order. These 5 items are
in
>an item 'lookup' table [A - Doll, B - Truck, C - Ball, D - Blocks, E -
>Bicycle]. Lets say ORDER # 113 is for a Doll and Bicycle (A and E). On
a
>query of ORDER # 113, we want the detail block to list all 5 ITEMs in
>checkbox form, but only show A and E to be checked. If later on, we add
F -
>Frisbee to the lookup table, we want F to dynamically show up in the queried
>ITEM detail block.
>
>

Not really sure I understand what you're after but.... couldn't you just use a post-query trigger to check if that item is included in the order, if it is set the checkbox to checked?

Simon Received on Fri Aug 24 2001 - 14:36:04 CEST

Original text of this message