You should be able to create an object that is a view of the SPList.
This view could have the filtering that you want.

Maui Williams | Solution Developer II, MCSD.Net
Avanade | West Region
2211 Elliott Avenue, Suite 200 Seattle, WA 98121

-----Original Message-----
From: TKO [mailto:themagicofdc@gmail.com]
Posted At: Thursday, October 26, 2006 12:39 PM
Posted To: microsoft.public.infopath
Conversation: Displaying DISTINCT items from a SharePoint list?
Subject: Displaying DISTINCT items from a SharePoint list?

Hi, I have a drop-down list pulls data from a SharePoint list.  How can
I make the drop down list show only distict items?

The SharePoint list is a list of all our clients and client project
codes.  Each client has multiple projects, and for each row, the list
stores the client name and a single project code.   In the InfoPath
drop-down list, I am using that SharePoint list as a datasource and
want to display a list of distict clent name.   Please help.

Many thanks in advance for any help anyone can provide!

-Tony