Choice Lists and Dependent Values vs. Reference Fields

[peterpan]

Hi,

i am working on a solution for a problem, a customer just brought up.

This is the scenario:
a customer has defined several categories for his service Desk (incident mgmt./form), value for each choice box depending on the prior selected choice boxes. The customer has 5 Categories, which i set up in e.g. category, subcategory, subsubcategory, etc.. The possible choices inside the subcategory choicebox depends on the selection of the choice in the category choicebox...and so on.

This works fine, while using the dependent fields inside the choice table.

Problem:
The customer has further restrictions on the choices to be shown in the dependent choiceboxes (the 2nd, 3rd, 4rth, 5th).

For example:
Several Choices (in the subcategory, subsubcategorie...) should only be visible to specific callers(depending on their company).

more detailed:
i choose a value in the first choice list (lets say the category). Out of the box, all prior (in the choice table) defined dependent values are filled in the second choice list (here subcategory).

How can i manipulate those values ? Using Client Scripts (e.g. with removeChoice), trying to alter the Dependent Choices in the ChoiceBox is not working, because all scripts are executed BEFORE the dependent values are filled in.

Using reference Fields as Dropdown is even harder, because, as far as i know, if i call a business rule in the ref.qualifier to backfill the reference field, i cant execute it on change of another field (like the company or other reference fields), to recalculate the shown values...

Any idea or help?
Did anyone had the same problem and a different solution he/she would like to share?

Thank you in advance
woha

[peterpan]

Does any1 have an idea?

[peterpan]

Does any1 has a solution, or a hint that could direkt me into the right direction?

[john_roberts]

Reference qualifiers will recalculate when form data is changed. Given the complexity of options and filtering I would definitely recommend using reference fields over choice lists. The one difference you'll need to handle is that the down-stream reference fields will not clear when higher-level fields are modified. You may need to have onChange client scripts to clear them.

[peterpan]

hi,

thank you for the input, and to give me a hint to the right direction... i figured it out now...