<link rel="stylesheet" type="text/css" href="dbnetsuite.css.ashx" /> <script language="JavaScript" src="dbnetsuite.js.ashx"></script>
<script> jQuery(document).ready( init ) function init() { jQuery("#tabs").show(); jQuery("#tabs").tabs(); var dbnetedit3 = new DbNetEdit("dbnetedit3"); with (dbnetedit3) { connectionString = "SamplesDatabase" fromPart = "[Order Details]" setColumnExpressions("OrderID","ProductID","UnitPrice","Quantity"); setColumnProperty("OrderID","foreignKey",true) setColumnProperty("ProductID","editControlType","TextBoxLookup"); setColumnProperty("ProductID","lookup","select productid, productname from products"); } var dbnetedit2 = new DbNetEdit("dbnetedit2"); with (dbnetedit2) { connectionString = "SamplesDatabase" fromPart = "Orders" setColumnExpressions("CustomerID","OrderID","OrderDate","RequiredDate"); setColumnProperty("CustomerID","foreignKey",true) setColumnProperty("OrderID","primaryKey",true) addLinkedControl(dbnetedit3); } var dbnetedit1 = new DbNetEdit("dbnetedit1"); with (dbnetedit1) { connectionString = "SamplesDatabase" fromPart = "Customers" setColumnExpressions("CustomerID","CompanyName","Address","City"); setColumnProperty("CustomerID","primaryKey",true) addLinkedControl(dbnetedit2); initialize() } } </script>
<table style="width:600px"> <tr> <td> <div id="tabs" style="display:none"> <ul> <li><a href="#tabs-1">Customers</a></li> <li><a href="#tabs-2">Orders</a></li> <li><a href="#tabs-3">Order Details</a></li> </ul> <div id="tabs-1"><div id="dbnetedit1"></div></div> <div id="tabs-2"><div id="dbnetedit2"></div></div> <div id="tabs-3"><div id="dbnetedit3"></div></div> </div> </td> </tr> </table>