Code On Time: Database Lookups

Tuesday, October 23, 2012Print Subscribe

Let’s make similar changes to the Order Details controller. We’ll make the ProductID lookup open in search mode upon creating a new order detail. When selecting a product, the Unit Price will also copy over into the order detail.

On the Controllers tab of the Project Explorer, double-click on OrderDetails / Fields / ProductID (Int32) –> Products field node.

Change the following settings:

Property	New Value
Data Value Field	ProductID
Data Text Field	ProductName
Copy	UnitPrice=UnitPrice
Search on Start	True
Activate if Blank	True
Lookup window description	Select a product.

Press OK to save the field, and press Browse in the top left corner.

Navigate to the Order Form page, and select any order. Create a new order detail record. A lookup will open prompting you to select a product.

Select a product, and you will see that Unit Price of the product has been copied into the order detail.

Labels: Database Lookups, Designer, Tutorials, Web Application Generator

Saturday, September 29, 2012Print Subscribe

Rows of List Box

The List Box allows lookup value selection from a scrolling box with a list of values. For example, the Employee Last Name field in Orders edit form has been configured as a List Box.

By default, there are 5 options displayed in the List Box at one time. This number can be changed using the Rows property.

Start the Project Designer. In the Project Explorer, switch to the Controllers tab and double-click on Orders / Views / editForm1 / c1 – Orders / EmployeeID node.

Change the Rows property:

Property	New Value
Rows	8

Press OK to save the data field. On the toolbar, press Browse.

Navigate to the Orders page, and edit a record. The Employee Last Name list box is now longer and displays more items at one time.

Labels: Database Lookups, Designer, Web Application Generator

Saturday, September 29, 2012Print Subscribe

Changing the Number of Columns of a Radio Button List

Lookup fields configured as a Radio Button List will have a single column by default. In the example below, the Employee Last Name lookup is a single-column radio button list.

Let’s configure Employee Last Name with multiple columns.

Start the Project Designer. In the Project Explorer, switch to the Controllers tab and double-click on Orders / Views / editForm1 / c1 – Orders / EmployeeID data field node.

Change the Columns property:

Property	New Value
Columns	3

Press OK to save. On the toolbar, press Browse.

Navigate to the Orders page, and edit a record. The radio button list for Employee Last Name field will be rendered in three columns.

Labels: Database Lookups, Designer, Web Application Generator