Include the client JavaScript & CSS libraries

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

Client-side configuration script

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

    ///////////////////////////////////////////////////////////////
	function init()
    ///////////////////////////////////////////////////////////////
	{
		var dbnetedit1 = new DbNetEdit("dbnetedit1");
		with (dbnetedit1)
		{
			connectionString = "SamplesDatabase"
			fromPart = "employees"

			bind("onRecordValidate", validateRow)
			bind("onColumnValidate", validateColumn)

			orderBy = "lastname"

			initialize()
		}
	}

    ///////////////////////////////////////////////////////////////
    function validateColumn(sender, args)
    ///////////////////////////////////////////////////////////////
    {
		switch(args.columnName.toLowerCase())
		{
			case "birthdate":
				if (args.columnValue) // Birth date is not null
					if (( new Date().getFullYear() - args.columnValue.getFullYear()) < 17) // Not a proper test !
					{
						args.message = "Person is not old enough";
						args.cancel = true;
					}
				break;

			case "hiredate":
				if (args.columnValue) // Hire date is not null
					if (args.columnValue.valueOf() > new Date().valueOf())
					{
						args.message = "Hire date cannot be in the future";
						args.cancel = true;
					}
				break;
        }
        
    }

    ///////////////////////////////////////////////////////////////
    function validateRow(sender, args)
    ///////////////////////////////////////////////////////////////
    {
        if (sender.mode == "insert") // Ignore records being inserted
            return;
        
        if (args.parameters["reportsto"]) // If ReportsTo has been modified 
            if ( args.parameters["reportsto"] != "" ) // and ReportsTo is not null
				if ( args.parameters["reportsto"] == args.currentRecord["employeeid"] ) // If ReportsTo same as Employee
				{
					args.message = "An employee cannot report to him/her self";
					args.columnToHighlight = "reportsto"; // Specify the name of the column to highlight
					args.cancel = true;
				}

        return;
    }
	</script>

HTML markup

    <table id="dbnetedit1">
        <tr>
			<td>
				<table>
					<tr>
						<td style="vertical-align:top">
							<fieldset>
							<legend>Personal Details</legend>
								<table>
									<tr>
										<td>Employee ID</td>
										<td><span ColumnExpression="EmployeeID" /></td>
									</tr>
									<tr>
										<td>Last Name</td>
										<td><span ColumnExpression="LastName" Style="width:100px" /></td>
									</tr>
									<tr>
										<td>First Name</td>
										<td><span ColumnExpression="FirstName"/></td>
									</tr>
									<tr>
										<td>Title</td>
										<td><span Style="width:100px" ColumnExpression="TitleOfCourtesy"/></td>
									</tr>
								</table>
							</fieldset>
							<span style="display:none" Edit="false" ColumnExpression="LastName + ', ' + FirstName" Label="Name" Browse="true"/>
						</td>
						<td style="vertical-align:top">
							<fieldset>
							<legend>Employment Details</legend>
								<table>
									<tr>
										<td>Birth Date</td>
										<td><span ColumnExpression="BirthDate" Required="true"/></td>
									</tr>
									<tr>
										<td>Hire Date</td>
										<td><span ColumnExpression="HireDate"/></td>
									</tr>
									<tr>
										<td>Reports To</td>
										<td><span ColumnExpression="ReportsTo" Lookup="select EmployeeID, LastName + ' ' + FirstName from Employees order by lastname, firstname"/></td>
									</tr>
								</table>
							</fieldset>
						</td>
						<td style="vertical-align:top">
							<fieldset>
							<legend>Address</legend>
								<table>
									<tr>
										<td>Address</td>
										<td><span Style="width:220px;height:30px;" EditControlType="TextArea" ColumnExpression="Address" /></td>
									</tr>
									<tr>
										<td>City</td>
										<td>
											<table cellpadding=0 cellspacing=0>
												</tr>
													<td><span ColumnExpression="City" /></td>
													<td>&nbsp;Region&nbsp;</td>
													<td><span Style="width:50px" ColumnExpression="Region" /></td>
												</tr>
											</table>
										</td>
									</tr>
									<tr>
										<td>Country</td>
										<td><span ColumnExpression="Country"/></td>
									</tr>
									<tr>
										<td>Phone</td>
										<td>
											<table cellpadding=0 cellspacing=0>
												</tr>
													<td><span ColumnExpression="HomePhone" Style="width:140px"/></td>
													<td>&nbsp;Ext&nbsp;</td>
													<td><span ColumnExpression="Extension"/></td>
												</tr>
											</table>
										</td>
									</tr>
								</table>
							</fieldset>
						</td>
					</tr>
				</table>
			</td>
			<td rowSpan="2" style="vertical-align:top">
				<fieldset>
					<legend>Employee List</legend>
					<div id="dbnetedit1_browsePanel" style="border:1pt solid silver;height:300px;width:150px;overflow-y:auto;padding:2px;"></div>
				</fieldset>
			</td>
        </tr>
        <tr>
            <td>
				<table>
					<tr>
						<td style="vertical-align:top">
							<fieldset>
								<legend>Notes</legend>
									<span ColumnExpression="Notes" Style="width:400px;height:60px" EditControlType="Html"></span>
							</fieldset>
						</td>	
						<td style="vertical-align:top">
							<fieldset>
								<legend>Photo</legend>
									<span UploadExtFilter="png,jpg,gif" ColumnExpression="Photo" MaxThumbnailHeight="120"></span>
							</fieldset>
						</td>
					</tr>
				</table>
			</td>
        </tr>
        <tr>
            <td colspan="2" style="text-align:right;border-top:1pt solid silver" ID="dbnetedit1_toolbarPanel"></td>
        </tr>
        <tr>
            <td colspan="2" ID="dbnetedit1_messagePanel"></td>
        </tr>
    </table>