A
Adam Harding
I have 3 cascading drop-down list boxes. My filtering works fine but my 2nd
and 3rd drop down list 'remembers' its options from the row before. To make
this clearer (Hopefully) here's an example
My list boxes are 1, 2 and 3.
1 2 3
A A A
My results in each box are A, B or C so if you select A in 1, you can only
select A in 2 and 3.
My problem comes after the 1st row. My second row is fine but if i select B
in Drop-down list box 1 in row 2, it gives me A and B in Box 2 and A and B in
Box 3. If i then go on to another row select C then Box two contains A, B or
C and so on.
Box Box Box
1 2 3
1st Row A A A
2nd Row B A A
B B
3rd Row C A A
B B
C C
My current list in the 3 box is over 200 items long, B box is 60 items long
and A box is 8 items long. Obviously this presents me with an enormous
problem and i have tried clearing the subsequest field prior to sorting but
the problem still presents itself. PLEASE SOMEONE HELP!
Could i use something like a context change event or similar, only thing is
i am NOT a programmer but need to work a way around this. Is it something to
do with the fact that my lists are populated from an Access DBase and 2ndry
Data Source that it refreshes when the form is opened BUT then does not
REFRESH again. Could i link this to the insert a new row on hte repeating
table maybe. It seems that Infopath holds the previous values somewhere. If
i could find that i could clear it as well.
Many thanks and Fingers Crossed.
and 3rd drop down list 'remembers' its options from the row before. To make
this clearer (Hopefully) here's an example
My list boxes are 1, 2 and 3.
1 2 3
A A A
My results in each box are A, B or C so if you select A in 1, you can only
select A in 2 and 3.
My problem comes after the 1st row. My second row is fine but if i select B
in Drop-down list box 1 in row 2, it gives me A and B in Box 2 and A and B in
Box 3. If i then go on to another row select C then Box two contains A, B or
C and so on.
Box Box Box
1 2 3
1st Row A A A
2nd Row B A A
B B
3rd Row C A A
B B
C C
My current list in the 3 box is over 200 items long, B box is 60 items long
and A box is 8 items long. Obviously this presents me with an enormous
problem and i have tried clearing the subsequest field prior to sorting but
the problem still presents itself. PLEASE SOMEONE HELP!
Could i use something like a context change event or similar, only thing is
i am NOT a programmer but need to work a way around this. Is it something to
do with the fact that my lists are populated from an Access DBase and 2ndry
Data Source that it refreshes when the form is opened BUT then does not
REFRESH again. Could i link this to the insert a new row on hte repeating
table maybe. It seems that Infopath holds the previous values somewhere. If
i could find that i could clear it as well.
Many thanks and Fingers Crossed.