Reducing value list

[sujat]

I have two fields for subject with drop down value list.

 

OPT 3 > value > Bio, Math ( Value list name Sub 3 )

 

OPT 4 > Value > Bio, Math, IT ( Value list name Sub 4 )

 

You first select OPT 3 and then OPT 4.

 

I want the subject selected in OPT 3 should be omitted from the value list of OPT 4.

 

I am at my wit's end trying to figure out how to do it.

 

Thanks.

[Maarten Witberg]

See if this demo by Ray Cologon does your job

[sujat]

Hi kjoe,

 

Thanks for the post.

 

I tried Ray Cologon's Dynamic Values. it is very good. It omits values from one list.

 

I have two lists as mentioned. I found this custom function at briandunning.com

 

AddRemove ( value ; content )

 

 

Let (

value_exists = PatternCount ( "¶" & content & "¶" ; "¶" & value & "¶" );

Case ( value_exists; MiddleValues ( Substitute ( "¶" & content ; "¶" & value & "¶" ; "¶" ) ; 2 ; 1000000 ); content & value & "¶" )

)

 

 

It is giving me the desired result. But it is giving a new problem too.

 

I am unable to select any value from the list. When I click the field, it drops down like a text field and I can't select any thing. When I go away from that field only the first value shows.

 

Thanks.