The Northwind Customers Application is a simple database application consisting of a grid application designed to display and search tabular data and a form application designed to create, read, update and delete record data.

Application Features

• 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.

• Customers DataGrid
• Customers Form

The Northwind Customers grid allows you to browse, filter and sort the customer accounts that you have created within the Northwind customers 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 CustomerID, CompanyName, ContactName, Address, City, Region, PostalCode, Country, Phone and Fax.
	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 Customers form allows you to edit, save or delete the selected customer record.

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
Customer ID	The Customer ID field Is editable only upon adding new records and must be unique within the Customers option.