InfoPath Dev

How do force infopath drop down list box not to show previously selected items?  My drop down list can get quite long, sometimes it's hard for the user to determine if they've picked an item before.  I've seen posts on how to fix this but it doesn't seem to work for me. 

 

Hi,

Can you verify "FILTERING LISTS FOR UNIQUE VALUES" steps in the below link.

http://www.infopathdev.com/blogs/greg/archive/2005/07/14/Create-a-Repeating-Cascading-List-from-a-Flat-Data-Source.aspx

 I believe that is the right direction but I can't seem to get it to work.  I'm not sure if I'm filtering on the correct data since all the previously selected Departments still show up.

 This is the image of the drop down box. 

Hi,

Can you verify attached xsn for this. And let me know still you have any issues with this.

Otherwise give me your schema or xsn. So that i will give exact solution for your issue.

Here is the link to the xsn.  I have a filter that i've since removed on there, in case your wondering where it came from.

 

http://www.infopathdev.com/forums/storage/39/38635/HealthCare_Space_Program_Version2.xsn

Hi,

 I have added filtering for "SectionTitle" dropdown in the attached xsn.

That works perfectly.  I'm trying to accomplish that in the field2 drop down as well.  So far i've tried:

not(my:field2 = current()/preceding-sibling::my:TOC/my:TOCgroup/my:group2/my:field2)
not(my:field2 = current()/following-sibling::my:TOC/my:TOCgroup/my:group2/my:field2)

not(my:Department = current()/preceding-sibling::my:Department)
not(my:Department = current()/following-sibling::my:Department)

 I'm wondering if this one is possible since i have the value set as my:TotalGrossDepartmentArea/my:Total and the display set as my:Department if this one will actually filter correctly.  Any ideas. 

Hi,

Can you change "Value" in the Department Dropdown Propeties to "Department. Then below filtering will work for you.

not(my:Department = current()/preceding-sibling::my:group2/my:field2)
not(my:Department = current()/following-sibling::my:group2/my:field2)

Verify attached xsn for better idea.

Can I filter based on what is displayed instead of the value?  If I change the value to Department then my field3 does not show the correct value which would be the Total Gross area of the department.