Customized List Box

[saumyashah90]

Hi,

I have List of Product and Sub Products.

Product
P1
P2
P3

Sub Product
SP1
SP2
SP3
SP4
SP5
SP6
SP7
SP8

P1 has SP1,SP2,SP3,

P2 has SP4,SP5

P3 has SP6,SP7,SP8

So by default when you click on P1, Sp1,SP2,SP3 will come and other will get grey out.

But i Dont need that.

Now requirement is:

When a Finance Advisor F1 comes, he is tagged to 3 SP's(SP6,SP7,SP8).

So when that F1 is clicked SP6,SP7,SP8 should be seen and others all gets greyed out.

Now for a particular month say October, he has sold only SP6 , I want to see only Sp6 in white and SP7 and SP8 in grey ,I dont want (others to come in the list as it creates confusion for user because other SP's are not tagged to him.)

Please let me know how to do it and also if you dont understand let me know.

[Gysbert_Wassenaar]

But when you select month Nov, SP6,SP8 are visible and others are greyed out.

But my requirement is only SP7 should be greyed out and others should  not be seen as they are not tagged under him.

That's not possible. There is only data for F1 in Nov. So the other SP values are always excluded for Nov.