I 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