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

[cvarrichio]

Woha, did you end up doing exactly what john.roberts suggested? I am attempting to do the exact same thing, and came to the same conclusion as john.roberts - that I would need to use a client script to update the downstream relationships. I am curious if you came up with something better.