|
Lookup wizard is a dropdown box with list of values. List of
values can be entered manually or retrieved from database table
(Lookup table).
Lookup
table
Custom Display field
Also you can use Custom Expression for Display field to display in dropdown
box several values from different fields with custom design.
How it looks in 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.
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.
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 checkboxes. A user can
select one or several values.
List of 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.
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 it, check in the dependent dropdown box This dropdown is dependent on ...
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.
|
