Newbie Questions

Re: Help with Duplicates

Rachel20J — Fri, 24 Jul 2009 13:45:38 GMT

I am using 2007, I know there is an option to use the unique values but it still lists all of those repeating values or i am just not telling it where to filter properly after that box is checked to display a unique value. I will look into the SQL side to see if there is anyway to prevent the duplicates. There are 28 items per value that I am seeking from drop down and it display all 28, but not to filter to the exact value that i want out of the 28 items that is linked to that one item. I just built my first database, it is all new, I must be leaving something out. Thank you for your time.

Re: Help with Duplicates

Hilary Stoupa — Thu, 23 Jul 2009 21:02:48 GMT

Are you using InfoPath 2003 or 2007? I'm guessing 2003, since 2007 has an option of not displaying duplicates....

You can use XPath (with preceding-sibling) to filter. You can also modify the SQL statement in your SQL data connection that you are using to return the list, or you can create a view in SQL that just has the distinct values you want for your list.

Help with Duplicates

Rachel20J — Thu, 23 Jul 2009 16:50:37 GMT

Preceding sibling is probably the best way to go to get rid of the duplicates in a single dropdown. The dropdown is using a datasource from SQL. I have it filtered on a ID number which works fine but there are too many duplicates. I've tried running all kinds of filters but i still can't reduce the list. Tried finding examples on just a dropdown, most of these preceding siblings has something to do with repeating list. Please help. Thanks.