test

The Northwind Orders Application is an example of an order processing application built using the Microsoft Northwind database. The application features a searchable grid as a means of navigating the orders table and a master / detail form to display the order record and associated order items.

Application Features

• Master / Detail Order Form
• Customisable HTML5 Order Report Output
• Quick Search
• Advanced Search
• Export data to multiple formats
• Form validation
• Create, Read, Update and Delete

For further help on the grid and form options click the respective tab pages below.

• Orders DataGrid
• Orders Form

The Northwind Orders grid allows you to browse, filter and sort the customer accounts that you have created within the Northwind orders module.

TIP: Clicking the pencil icon will launch the form in edit mode for the selected record.

Toolbar

Toolbar Item	Description
	The Quick Search option can be used to quickly filter the grid. NOTE: Fields searched by the Quick Search option are OrderID, CustomerID, ShipName, ShipAddress, ShipCity, ShipRegion, ShipPostalCode and ShipCountry.
	Add New record.
	The search button can be used if a more detailed search is required.  Using this option the grid can be filtered by any value in any field.
	The Export button is used to export the grid records to an external, downloadable data file.  Supported file formats are MS Excel, CSV, XML and JSON.  At time of export there are also options to specify which columns are included in the exported data along with other file type specific options.
	The Settings button can be used to customise the column layout of the grid by adding or subtracting grid columns.  The status of the grid can also be saved so that the required grid status can be loaded again at a later time.
	Refresh the grid.
	Calls context sensitive help system.

The Northwind Orders form allows you to edit, save or delete the selected order record and its associated order items.

Toolbar

Toolbar Item	Description
	Add new record. NOTE: When in Add mode the form toolbar buttons will be replaced with Add and Cancel buttons.  Add will add the new record and Cancel will return the form to Edit mode.
	Save the form.
	Delete the current record.
	Call the context sensitive help system.
	Return to calling grid.

Mandatory Fields

Field Name	Notes
Order ID	The Order ID field is automatically populated upon adding a new order to the orders table.
Customer ID	The Customer ID field Is editable only upon adding new records and must be unique within the Customers option.