Controls

Re: Duplicated ID's inside datasource dropdown box

adamrharding — Tue, 09 Oct 2007 19:05:19 GMT

I think the follwing would be easier than writing code. It would be very easy to do with a query in SQL or Access so export the list and use a query with the SELECT DISTINCT statement in SQL to just pull back the DISTINCT values. Sorted Cheers

Re: Duplicated ID's inside datasource dropdown box

adamdale — Tue, 09 Oct 2007 15:04:01 GMT

Ok thanks. Do you know anywhere i can get hold of some sample bits of code to achieve this?

Many thanks

Re: Duplicated ID's inside datasource dropdown box

adamrharding — Tue, 09 Oct 2007 14:57:56 GMT

Not natively. Unfortunately you would have to filter your list to achieve this or write some code to dedupe it.

Sorry

Duplicated ID's inside datasource dropdown box

adamdale — Tue, 09 Oct 2007 13:53:22 GMT

Hello!!

I have an infopath form that gains ID numbers from a sharepoint list. The problem is some of my ID numbers are duplicated. Basically i created a datasource, this enables the ID numbers to be displayed inside a dropdown box. However some of them are duplicated. Is there a way i can just get one of them to display?

Many thanks