|
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. 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 article
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. |
