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 addDlg = $('#addCategoryDialog').dialog({
			title: "Add Category",
			bgiframe: true,
			width: 570,
			modal: true,
			autoOpen: false,
			hide: 'slide',
			resizable: false
		});

		var dbnetedit1 = new DbNetEdit("dbnetedit1");
		with (dbnetedit1)
		{
			connectionString = "SamplesDatabase"
			fromPart = "Products"

			setColumnExpressions("ProductName","CategoryID")
			setColumnProperty("CategoryID","lookup","select CategoryID, CategoryName from Categories")
	
			bind("onInitialized", addNewCategoryButton);
			bind('onDependentListLoaded', assignCategoryId);

			orderBy = "ProductName";
			initialize()
		}

		var dbnetedit2 = new DbNetEdit("dbnetedit2");
		with (dbnetedit2)
		{
			connectionString = "SamplesDatabase";
			fromPart = "categories";
			deleteRow = false;
			navigation = false;
			insertRow = false;
			search = false;
			fixedFilterSql = "1=2";

			setColumnExpressions("CategoryName","Description")

			setColumnProperty("CategoryName","required",true)
			setColumnProperty("Description","required",true)

			bind('onRecordValidate', checkForDuplicateCategory);
			bind('onPageLoaded', initialiseInsert);
			bind('onRecordInserted', updateCategoryList);

			initialize();
		}
	}

	function addNewCategoryButton(control) 
	{
		var button = control.addInputControlButton('CategoryID');
		button.onclick = function() { $('#addCategoryDialog').dialog('open'); };
		var img = document.createElement("img");
		img.src = "../../appframework/images/add.png"
		button.appendChild(img);
	}

	function checkForDuplicateCategory(sender, args) {
		if (args.parameters["categoryname"] == null)
			return;

		var sql = "select categoryname from categories where categoryname = @categoryname";

		var params = { categoryname: args.parameters["categoryname"] };

		if (sender.executeSingletonQuery(sql, params)) {
			args.message = "A category with the same name already exists";
			args.cancel = true;
		}
	}

	function initialiseInsert(control) {
		if (control.totalRows == 0)
			control.initializeInsert();
	}

	var categoryId = null;

	function updateCategoryList(sender, args) {
		window.categoryId = args.id;
		DbNetLink.components["dbnetedit1"].refreshListOptions("categoryid")
		$('#addCategoryDialog').dialog("close");
	}

	function assignCategoryId(sender) {
		if (window.categoryId)
		{
			DbNetLink.components["dbnetedit1"].setInputControlValue("categoryid", window.categoryId);
			window.categoryId = null;
		}
	}
	
	</script>

HTML markup

<table>
	<tr>
		<td>
			<div id="dbnetedit1"></div>
		</td>
	</tr>
</table>

<div id="addCategoryDialog">
	<div id="dbnetedit2"></div>
</div>