I created Three Lists :
- Countries {Title}
- Regions {Title,Country(Lookup link with Title of Countries List)} and
- States {State,Region Name(Lookup link with Title of Regions List), Country Name (Lookup link with Title of Countries List)}
In the States List , I added Script Editor Web Part to Newform.aspx , but it didn't filter The Regions Name with Selecting Country Name this is The Script That Embed With Page :
<script language="javascript" type="text/javascript" src="../../jquery-1.8.2.js"></script>
<script language="javascript" type="text/javascript" src="../../jquery.SPServices-0.7.2.min.js"></script>
<script language="javascript" type="text/javascript">
$(document).ready(function() {
$().SPServices.SPCascadeDropdowns({
relationshipList: "Regions",
relationshipListParentColumn: "Country",
relationshipListChildColumn: "Title",
relationshipListSortColumn: "ID",
parentColumn: "Country_x0020_Name",
childColumn: "Region_x0020_Name",
debug: true
});
});
parentColumn
andchildColumn
should be display names, not internal names:Country Name
andRegion Name