Lookup wizard is a list of values. List of values can be entered manually (List of values option) or retrieved from the database table (Lookup table option).

List of values

Use 'plus'/'minus' buttons to add/delete values and buttons with arrows to order them.

Lookup table

Select the database table to retrieve values from, then select link and display field from that table. Other available options are described below.

Display field

You can use Custom Expression for the Display field to display in dropdown box several values from different fields with custom design.

How it looks in the browser:

WHERE expression

The WHERE expression allows to sort dropdown box content. In our example if you put "phone like '%555%'" into WHERE box only Contacts with 555 in phone number will be displayed.

Autofill

You can auto-fill several fields on the Add/Edit pages with values from the lookup table.

Add new items on the fly

This option puts Add new link next to dropdown box allowing to add new items right on Edit/Add page. Add new item popup is a fully-featured add page.

Linked dropdown boxes

You can use dependent dropdown boxes, where values shown in the second dropdown box depend on the value you’ve chosen in the first one.

To do this, select the This dropdown is dependent on ... check box. Choose Category control - field, defining list of categories and Category field – field from dependent table, containing category value. After setup press Test it button, to check how it will work.

Edit page with dependent dropdown boxes (Model field content is dependent on Make field value):

You can also use chain of dependent dropdown boxes. For example, Supplier field content can depends on Products field, which in its turn depend on Products category field.

Also you can have more than one dependent dropdown box tied to the same master dropdown control.

Appearance of lookup wizard

Lookup wizard as Edit box with AJAX popup

This feature is explained in the following AJAX-based features.

Lookup wizard as list with search

Once Select button is clicked user is presented with the searchable lookup table. Lookup table appearance is fully customizable in Visual Editor.

Lookup wizard as checkbox list

List of values is displayed as set of check boxes. A user can select one or several values.

Multiline

If you set Multiline to any value greater then one this field will appear as a listbox on Add/Edit pages. To select multiple entries hold Ctrl key while choosing values.