Advertisement
In this article I explain how to create cascading dropdown based on state and city.
I created State, City and Address list with lookup.
Open Address list, Click on “Customize Form” under List tab. It will open InfoPath designer, now we can customize List Form.
Right click on City dropdown list control -> select Drop-Down List box Properties.
In Data Source -> click “Add” button.
In Data Connection wizard, click “Next” button
Select “SharePoint library or list” -> Click “Next” button.
Enter “SharePoint site details” -> Click “Next” button.
Select a list of library, choose “City” -> Click “Next” button.
In select fields: select State, City Name and ID -> Click “Next” button.
Next screen, click “next” button.
Leave the default name (City1) and click “Finish” button.
We can see now Data Source of Drop-down list box is City1
Click on tree button to select XPath, in Entries section.
Click “Filter Data” button.
Click “Add” button in Filter Data
Choose a field or group... in the first drop-down list.
Choose City1 Data source and select State -> click “Ok” button.
Now select a field or group… in the last drop-down list
Select Main as Data Source then choose State in data Fields -> click “OK” button
Click “OK” to close specify Filter Conditions dialog
Click “OK” to close Filter Data dialog
Click “OK” to close Select a Field or Group
In Drop Down List box properties, choose d:ID in Value: section -> click “OK” to close this
Now Save and Publish the InfoPath Form view. Go to Address list and Click new item.
Here we can see only state related cities in the dropdown list.
TCU Football
ReplyDeleteTCU Horned Frogs
USC Football
USC Trojans
Michigan State Football
Michigan State Spartans
UCF Football
UCF Knights
Penn State Football
Penn State Nittany Lions
Stanford Football
Stanford Cardinal
Ole Miss Football
Ole Miss Rebels
Wisconsin Football
Wisconsin Badgers
US Open Tennis
ReplyDeleteUS Open
US Open Tennis 2018
US Open 2018
2018 US Open
US Open 2018
2018 US Open Tennis
US Open 2018 Schedule
US Open 2018 Tennis Schedule
US Open Tennis 2018 Schedule
U.S. Open
U.S. Open 2018
2018 U.S. Open
US Open Tennis Live
US Open Tennis Live Stream
US Open Tennis Live Streaming
US Open Live
US Open Live Stream
US Open Live Streaming
US Open 2018 Live
US Open 2018 Live Stream
US Open 2018 Live Streaming
US Open Tennis 2018 Live
US Open Tennis 2018 Live Stream
US Open Tennis 2018 Live Streaming
US Open 2018 TV Channel
US Open 2018 Dates
US Open Tennis Championships
US Open Tennis Championships 2018
https://the-usopen.co/
how to watch World Series 2018 live The 2018 Major League Baseball is set to begin on October 23, and a potential Game 7 is scheduled for October 31.
ReplyDeletehttps://worldserieshints.com/
Thank you so much for posting this. I really appreciate your work. Keep it up. Great work!Best software training company with placement in Hyderabad
ReplyDeleteThis comment has been removed by the author.
ReplyDeleteI am looking for and I love to post a comment that "The content of your post is awesome" Great work!
ReplyDeleteBusiness Analytics Course In Hyderabad|Business Analytics Training