SPServices: Cascading Drop-Down List in SharePoint 2010 List using jQuery

1. Create Cities custom list:

2. Create Districts Custom list: with City lookup column

3. Create Ward custom list: with District lookup column

4. Create Addresses list: with City, District, Ward lookup columns

Using following scripts in the NewForm.aspx of Addresses

<script src="/TimeSheet/jQuery%20Libraries/jquery-1.4.2.min.js" type="text/javascript"></script>

<script src="/TimeSheet/jQuery%20Libraries/jquery.SPServices-0.5.4.min.js" type="text/javascript"></script>

<script language="javascript" type="text/javascript">

        $(document).ready(function() {

            $().SPServices.SPCascadeDropdowns({

                relationshipList: "Districts",

                relationshipListParentColumn: "City",

                relationshipListChildColumn: "Title",

                relationshipListSortColumn: "ID",

                parentColumn: "City",

                childColumn: "District",

                promptText: "Choose District...",

                debug: true

            });

            $().SPServices.SPCascadeDropdowns({

                relationshipList: "Ward",

                relationshipListParentColumn: "District",

                relationshipListChildColumn: "Title",

                relationshipListSortColumn: "ID",

                parentColumn: "District",

                childColumn: "Ward",

                promptText: "Choose Ward...",

                debug: true

            });

        });

</script>

Hope this help!