Include the Javascript library file

Client-side script

window.onload = initialise

//////////////////////////////////////////////////////////////////////////////////////////////
function initialise()
//////////////////////////////////////////////////////////////////////////////////////////////
{
	customerCombo = new DbNetCombo("customers")
	orderCombo = new DbNetCombo("orders")
	productCombo = new DbNetCombo("products")

with ( customerCombo )
	{
		connectionString = "samples"
		sql = "select customerid,companyname from customers order by companyname"
		addLinkedCombo( orderCombo, "customerid" )
	}

with ( orderCombo )
	{
		connectionString = "samples"
		sql = "select orderid,orderdate from orders where customerid = @customerid"
		dateFormat = "D"
		addLinkedCombo( productCombo, "orderid" )
	}

with ( productCombo )
	{
		connectionString = "samples"
		sql = "select '', productname & ' (' & quantity & ')' " +
			"from products, [order details] " +
			"where products.productid = [order details].productid " +
			"and orderid = @orderid"
	}

customerCombo.load()
}

Customer	Order Date	Product (Qty)

Include the Javascript library file

Client-side script

HTML