Include the client JavaScript & CSS libraries

	<link rel="stylesheet" type="text/css"  href="dbnetsuite.css.ashx"/>
	<script language="JavaScript" src="dbnetsuite.js.ashx"></script>

Client-side configuration script

	<script>
	jQuery(document).ready( init )

	function init()
	{
		var dbnetedit1 = new DbNetEdit("dbnetedit1");
		with (dbnetedit1)
		{
			connectionString = "SamplesDatabase"
			fromPart = "Customers"
			setColumnExpressions("CompanyName","Address","postalcode","city","region", "country");
			setColumnLabels("CompanyName","Address","Zip","City", "State","Country");

			fixedFilterSql = "country = 'USA'"

			bind("onFieldValueChanged", getCityAndState);

			initialize()
		}
	}

	function getCityAndState(sender, args)
	{
		switch(args.editField.getAttribute("columnName"))
		{
			case "postalcode":
				var data = sender.executeSingletonQuery("select * from zip where zip = @zipcode", {zipcode : args.editField.value});
				if (data)
				{
					sender.setInputControlValue("city", data.city)
					sender.setInputControlValue("region", data.state)
					sender.setInputControlValue("country", "USA")
				}
				break;
		}

	}


	</script>

HTML markup

	<div id="dbnetedit1"></div>