Drop down list box problem

[kenneth_kcho]

Hi all,

I created three drop down list box in my infopath. 1 call 'Department',
1 call 'Location' and 1 call ' position'. 'Location ' and 'position'
are grouped in a repeat table. My filter criteria is that:

Department Location Position
1 IT Block A Staff
2 IT Block C Visiter
3 HR Block B Manager

If I select 'IT' and 'Block A', Position must show 'Staff'.
However, when I select again in next row, if I select 'IT' and 'Block
C', Infopaht still show 'Staff'.

It seems that Infopath always remember my first choose 'Block A'. Even
though my next choose is 'Block C', it can't update. How can I solve
this.

Also, 'Location ' and 'position' are grouped in a repeat table. That
mean I let user select more than one location and position per one
department. However, the data in this repeat table must be the same.
e.g. I select 'Block A' then select 'Block C', 'Block A' also become
'Block C'

How can I solve these problem. Thanks........

 

[suresh Reddy]

Hi, try out this hope this will help you.

http://infopathdev.com/howto/tutorials/default.aspx?i=a37cdc1933854c01b708dc4e99e84f8b

Thank you

 

[kenneth_kcho]

Hi Reddy,

Thanks for your help.

But, according to this artical, when I try to Clear the field value
when other field change, all vaules are cleared and can't submit.

How can I solve this problem

Thanks.......