Re: [oracle-dev-l] Another Poplist question
From: Pieter <phuiberts-REMOVE_at_ivwnet.com>
Date: Thu, 19 Sep 2002 23:05:11 -0400
Message-ID: <3D8A9067.8040200_at_ivwnet.com>
>>Hello,
>>I am sorry to bug you all with my poplist questions, but it seems the
>>best option for my Form.
>>
>>Anyway, I have a form in Forms6 that has 2 poplist items. Item 1 shows
>>Projects, and Item 2 shows sub divisions of the selected project in Item
>>1. What I want is to have the second poplist (item 2) to show
>>sub-headings related to the project value selected in Item 1. When the
>>items (or at least item 2) are comboboxes I can make it work by using a
>>WHEN-LIST-CHANGED-trigger on item 1 and re-populate item 2 with a
>>recordgroup that takes the value from item 1. When I change item 2 to
>>poplist it does not work any more. I can load the values at the start
>>into the list item if I load the poplist before I bring the form into
>>the Normal mode, but when I than select another project, my
>>WHEN-LIST-CHANGED-trigger gives my an error; FRM-41331: Could not delete
>>element from item 2, followed by FRM-40337: Cannot populate the list
>>from recordgroup. As this works correctly when I change item 2 to
>>combobox, I know that the record group and its query are correct.
>>
>>My guess is that the problem is the removal of the list items in item 2
>>before getting the new set in. However, how (and if) can I make it work?
>>
>> I do not want to settle for a LOV or so, that would be very
>>inconvinient to the user and degrade the use of my form (potentially the
>>application as I deal with the morst important input form of the
>>application).
>>
>>Thanks for you help,
>>Pieter
Date: Thu, 19 Sep 2002 23:05:11 -0400
Message-ID: <3D8A9067.8040200_at_ivwnet.com>
I already have that, but it does not work....
Daniel Morgan wrote:
> "Pieter J.D. Huiberts" wrote: > >
>>Hello,
>>I am sorry to bug you all with my poplist questions, but it seems the
>>best option for my Form.
>>
>>Anyway, I have a form in Forms6 that has 2 poplist items. Item 1 shows
>>Projects, and Item 2 shows sub divisions of the selected project in Item
>>1. What I want is to have the second poplist (item 2) to show
>>sub-headings related to the project value selected in Item 1. When the
>>items (or at least item 2) are comboboxes I can make it work by using a
>>WHEN-LIST-CHANGED-trigger on item 1 and re-populate item 2 with a
>>recordgroup that takes the value from item 1. When I change item 2 to
>>poplist it does not work any more. I can load the values at the start
>>into the list item if I load the poplist before I bring the form into
>>the Normal mode, but when I than select another project, my
>>WHEN-LIST-CHANGED-trigger gives my an error; FRM-41331: Could not delete
>>element from item 2, followed by FRM-40337: Cannot populate the list
>>from recordgroup. As this works correctly when I change item 2 to
>>combobox, I know that the record group and its query are correct.
>>
>>My guess is that the problem is the removal of the list items in item 2
>>before getting the new set in. However, how (and if) can I make it work?
>>
>> I do not want to settle for a LOV or so, that would be very
>>inconvinient to the user and degrade the use of my form (potentially the
>>application as I deal with the morst important input form of the
>>application).
>>
>>Thanks for you help,
>>Pieter
> > > In the record group SQL statement for the second list add: > > WHERE some_value = :block_name.item_name > > of the field populated by the first list. > > Daniel Morgan >Received on Fri Sep 20 2002 - 05:05:11 CEST