cascading drop down in repeated table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mike - 05 Oct 2006 10:21 GMT

I have cascading dropdown-listboxes to select hierarchical-based options.
Every child dropdown-listbox has a filter-rule, based on the selection of
the parent dropdown listbox.

All dropdown-listboxes are stored in a repeated table to make more than one
complete selection-element possible.

The first selection works correct.

If I fill in another element in the repeated table, the child
dropdown-listboxes of the new element contains the values of the previous
child dropdown-listboxes from the element before, and not only my filtered
data.

Any suggestions?
Thanks,
Mike

Reply to this Message

S.Y.M. Wong-A-Ton - 06 Oct 2006 05:41 GMT

Did you use the current() function when setting up the filter?
---
S.Y.M. Wong-A-Ton

> I have cascading dropdown-listboxes to select hierarchical-based options.
> Every child dropdown-listbox has a filter-rule, based on the selection of
[quoted text clipped - 13 lines]
> Thanks,
> Mike

Reply to this Message

neskire - 15 Oct 2007 13:44 GMT

Hi Mike,

Had the same problem - solved it by using a hidden textbox outside the
repeating table (since current() was no use).

Made a rule on the first dropdownlist, that set the text-property to the
value of the dropdownlist - in the second dropdownlist I filtered using the
value of the textbox.

This way I didn't get the values of both dropdownlists present in the
repeating tables - not the nicest piece of code ever written, but it does the
job.

>I have cascading dropdown-listboxes to select hierarchical-based options.
>Every child dropdown-listbox has a filter-rule, based on the selection of
[quoted text clipped - 13 lines]
>Thanks,
>Mike

Reply to this Message