Dynamic Update in infopath from Sharepoint List

Step 1)

Create a SP list with two columns Country and State.

Step 2)

Now in infopath create 2 fields Country and State as dropdown fields.

Step 3)

Create a data connection to receive from SP list which we created in step 1. Add the 2 fields from list in data connection wizard.

Step 4)

Select the Country dropdown box in infopath form and point the Country data to the list using the data source which we created in step 3.

Most important select the Check box

“Show only entries with unique display names”

Step 5)

Select the State dropdown box in infopath form and point the state data to the list using the data source which we created in step 3 and filter this data to the Country from list to the Country which we created in infopath form

Step 6)

Cascading update in infopath from SP list