Dependent validation - lists and lookup combo

hi, headexperiment, hope this helps

Hi Watersev,

Thanks for looking at it for me - much appreciated. It doesn't seem to have worked..?

Populating Option_Carea and/or option_cf_team seems to prevent the drop-down in from working. Am i doing something wrong?

Thanks,

HE.

hi, as far as I understood your question:

If "option_carea" is "Any", I want "option_cf_team"'s validation to come from "cf_teams"
If "option_carea" is "East", I want "option_cf_team"'s validation to come from "cf_teams_east"
If "option_carea" is "West", I want "option_cf_team"'s validation to come from "cf_teams_west"

Next door named "option_woe"
If "option_carea" is "Any", and "option_cf_team" is "Any", I want "option_woe"'s validation to come from "cf_woes"
If "option_carea" is "East", and "option_cf_team" is "Any", I want "option_woe"'s validation to come from "cf_woes_east"
If "option_carea" is "West", and "option_cf_team" is "Any", I want "option_woe"'s validation to come from "cf_woes_west"

as far as I can see it works. So if Any is selected in option_cf_team then option_woe come from woes depending on option_carea. What exactly does not work?

Thanks watersev. It works, partly

But if, for example, I set option_carea to "West" and option cf_team to "Avon", the dropdown on option_woe freezes, when it should offer only "Sam".

??

hi, I beg your pardon I did not read to the end, this should address that.

As pardon me-gesture I've added clearing of option_cf_team and option_cf_woe when Option_Carea is changed.

Perfect. Does the job exactly.

Better go off and do my homework on:

Please Login or Register  to view this content.

And:

Please Login or Register  to view this content.

Many thanks. HE.