BS: Drop-down allows you to choose a value from the list

There are 3 concepts:

 

1. The list of ID+Display text are defined inside the field. In the Input field you can only see the Display text, but the ID is saved.
Use this type if the simple variant is enough or if you don't want to see the ID.

Note: If SQL command is necessary, it takes more time to open a window.

2. In the drop-down you can see the ID and additional fields  and choose the ID.
This list is created in the moment of the view of the list.

This variant does not reduce the performance of the program. Use this variant if possible

Source can be
- manual values
- SQL select command

- odata (bsl) command

3. Other type of Drop-down as Date, Bitmap or Color

   

 

 

If the drop-down value defined, the system inserts the drop-down icon right of the field automatically.
Object name of this drop-down icon is always object name + "_p", example "utf1_p"

 

It is possible to modify standard drop-downs. See Drop-down.script

 

Open drop-down window:: use drop-down without properties:

dw_1.item.myfield.dropdown

 

Define Drop-down properties