|
Lookup
wizard - dropdown box with list of values. List of values
can be entered manually or retrieved from database 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.
Lookup
wizard as Edit box with AJAX popup
This feature is explained in the following article
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.
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:
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.
|
