https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/7744.aspxWed, 28 Sep 2005 14:27:06 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:7744Agni Jonnalagadda0https://www.infopathdev.com:443/forums/thread/7744.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=7744Hi,<br />Please look at our tutorials for lists<br /<a target="_blank" href=http://www.infopathdev.com/howto/tutorials/default.aspx?s=Lists>http://www.infopathdev.com/howto/tutorials/default.aspx?s=Lists</a><br /><br />Agni<br />InfoPath Dev Indiahttps://www.infopathdev.com:443/forums/thread/4934.aspxTue, 27 Sep 2005 12:00:29 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:4934Kiptodd0https://www.infopathdev.com:443/forums/thread/4934.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=4934I have connected a pull down feild1(ITEM) within a repeating table to data in SQL. I have setup another pull down to auto increment a number in feild2(PartNumber)<br />The pull down Feild1(ITEMS) list all the documents in all Sharepoint document libraries,and Feild2(PartNumber)Autogenerates a Unique incremented Number)<br /><br />I am trying to get the data to NOT show documents already selected in previous feilds.<br /><br />Example:<br />SQL UserData table contains: File1.doc file2.doc file3.doc<br /><br />In Infopath I select Feild1 (ITEMS) and select file1.doc<br />Feild2(PartNumber) AutoGenerates a Unique PartNumber<br /><br />Now I select ADD ITEM<br />In the Pull Down Feild1(ITEM) I need the list not to show the item previously selected.<br /><br />I used a filter and got it to work, However it only omits the first ROW Selection.<br /><br />Can someone help with this?<br /><br /><br />Kip Bautista<br />KTB Dezines<br />KTBDezines@netscape.net