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 ...