I have a weird situation. I have 2 list boxes where in first box I have 3 fields and 2 fields from this list box are bifurcated to 2 more fields each to have 4 fields in another list box.
i.e.
A - 1st list box
Example fields : Aa Ab Ac Ad Ae-
A1 - second List Box
Example fields : Aa1 Aa2 Ab1 Ab2 Ac
Note - Sales / profit values of Aa1 + Aa2 = Total of Aa in the First list box. In a way they are in hierarchy and same with Ab1 and Ab2
If I am selecting any Year and Period - and
when I am selecting A and A1 situation is OK but when I am selecting A and B1 - it automatically wipes out all the list boxes and selections on the dashboard (here in this case Valid Year and period). I am not getting why this happening. There are no document / text object level triggers anywhere in the document.
Has anyone got this issue ever? Please let me know about it.
PLEASE FIND the Sample Data where I am getting this issue.
You have used generic names in your post above (A, B, A1, and so on...) but your actual post contains actual field names. What is B and B1, B2 here???
Although I do have a theory that maybe A and B1 do not ever come together. If that's true there is no way you can select A and then B1 because they contradict each's other selection, but I cannot say it confidently before checking it out in your application.
Hi Sunny - I have amended the original post and now I made it clear. Field 1 and Field2 are in a way in hierarchy. i.e. when fields of list box A are selected dependent fields from A1 are getting highlighted which is correct. But when I am playing around to select the unselected fileds from list box A again, all the selctions getting wiped out. which should not happen.
