Sample Applications / Order Form / Orders

  Configuring Lookup Fields

Table of Contents
Sample Applications / Order Form / OrdersPrint||
Configuring Lookup Fields

When creating a new order, the first item that will be entered will probably be the customer. Due to the denormalized nature of Northwind database, the customer information is stored in the table Customers, and the Orders table references a customer via a foreign key field CustomerID. Upon creating a new order, it would be convenient if the user were prompted to either select an existing customer or create a new one. When the customer is selected, the shipping information should be copied from the customer to the order.

Switch back to the Designer. In the Project Explorer, double-click on Order Form / c101 / view1 / grid1 / CustomerID –> CustomerCompanyName / CustomerID (String(5)) field reference node.

CustomerID field reference node under the CustomerID data field of grid1 view.

Enter the following settings for CustomerID:

Property New Value
Data Value Field CustomerID
Data Text Field CompanyName
Copy

ShipName=ContactName
ShipAddress=Address
ShipCity=City
ShipRegion=Region
ShipPostalCode=PostalCode
ShipCountry=Country

Search on Start true
Activate If Blank true
Lookup Window Description Select a customer.

Press OK to save the field.

When the customer has been selected, we’d want the application to prompt the user to select the employee handling the order. To make this part easier, let’s add photos of each employee in the lookup.

In the Project Explorer, double-click on Order Form / c101 / view1 (Orders) / grid1 / EmployeeID –> EmployeeLastName / EmployeeID (Int32) field reference node.

EmployeeID field reference node under the EmployeeID data field of grid1 view.

Change the following settings for EmployeeID:

Property New Value
Activate If Blank true
Lookup window description Select an employee.

Press OK to save the record.

Switch to the Controllers tab at the bottom of the Project Explorer. Expand the Fields and Views nodes of Employees controller. Drag and drop Employees / Fields / Photo (Byte[]) field node onto Employees / Views / grid1 view node.

Dropping the Photo field node onto 'grid1' view node.     A Photo data field has been created in 'grid1' view.

On the Project Designer toolbar, press Browse, and wait for the application to load. Navigate to the Order Form page, and press New Orders on the action bar. You will be prompted to select a customer.

When a new order is created, a lookup will open that will prompt selection of a customer.

When you search for and select a customer, you will then be prompted to select an employee. You can see the photo for each employee as well.

Lookup screen prompting selection of an employee. The photo for each employee is displayed.

Select the employee, and you will see that the shipping fields have been populated from the selected customer.

New Orders form with Customer and Employee selected. Shipping information from the customer has been copied over.