Hi, I simply cannot get my head around this one....
I have a SharePoint list with the following structure:
Col_A Text
Col_B Int (1-5)
Col_C Text (fixed value ei. A, B, C, D, E)
Now on my form I got three dropdowns:
DD1: Values 1-5 (related to col_B)
DD2: Values A-E (related to col_C)
And here is the challenge
DD3: Should display values from Col_A WHERE Col_B >= DD1 AND Col_C = DD2
How do I do this? ListLookup control only filters by one column.... was thinking of using some jQuery to query my list.