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/124401.aspxWed, 25 Aug 2021 18:36:19 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:124401Netaji0https://www.infopathdev.com:443/forums/thread/124401.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=124401I have a excel sheet and there were 100 record. Column name is ID i.e., 1 to 100 I have imported all 100 records in SP list - List B List A- create SP list and design infopath form where I have select the drop-down control and went to drop down properties select 'get choice from external data source'. Data source is list B and select ID column. Clicked on show only entries with unique display name Now , in my list A suppose I have already submitted some data 1 to 10. If I select from drop-down 11 and successfully save the data. Some things if I try and select value 5 some I am able to save the data. Which should not be because ID 5 is already in list A. Thanks