Introduction

Drop-downs can be added to grids or form fields on screens using a dedicated view. The below image shows a drop-down on a grid.

Drop-downs can be styled to suit your needs, including row colours, row heights and mouse-over colours, see Adding Styling to a Drop-Down View.

Create a Drop-Down on a Grid

1. Create a view containing the data you wish to display in your drop-down list
   
   

   Expand
   title How?
   Anchor CreateView CreateView This can be configured from your Insert excerpt _erd _erd nopanel true  by clicking on the table header, or from a screen that currently displays a view of the data, by right-clicking and choosing  Insert excerpt _show_table_configuration _show_table_configuration nopanel true . In the  Insert excerpt _tables _tables nopanel true 's  Insert excerpt _property_tabs _property_tabs nopanel true , expand the Views section Click  Insert excerpt _addIcon _addIcon nopanel true  to create a new view Give the view an appropriate name and press Insert excerpt _save _save nopanel true We recommend the view name is prefixed with DD_ to indicate it's for a drop-down In the View Attributes section, select the  Insert excerpt _attributes_icon _attributes_icon nopanel true  icon to open the Available Attributes selector Drag across the attributes you wish to see in the drop-down view into the View Attributes section on the  Insert excerpt _property_tabs _property_tabs nopanel true , then press OK (Optional) On the the Insert excerpt _property_tabs _property_tabs name style nopanel true  for the new View, choose or create new styles as , if required See Adding Styling to a Drop-Down View

   
   

2. Insert excerpt
   _pin _pin nopanel true

    either the table or drop-down view tab to keep it open
3. On a screen containing a

   Insert excerpt
   _grid _grid nopanel true

   , click on the attribute header for the column where you want to display drop down fields
4. The View Attribute

   Insert excerpt
   _property_tabs _property_tabs nopanel true

   will open
5. On the

   Insert excerpt
   _property_tabs _property_tabs name style nopanel true

   , untick Read Only
6. On the 

   Insert excerpt
   _property_tabs _property_tabs nopanel true

   , drag across your drop-down view into the Selection View field, found in the Drop Down Settings section of the View Attribute properties
   
   

7. Insert excerpt
   _save _save nopanel true

    the properties
8. Close and reopen the screen, then 

   Insert excerpt
   _lock _lock nopanel true

    the screen to see the changes

Create a Drop-Down on a Form

1. Create a view containing the data you wish to display in your drop-down list
   

   Expand
   title How?
   See How? above.

   
   

2. Insert excerpt
   _pin _pin nopanel true

    either the table or drop-down view tab to keep it open
3. On a screen containing a

   Insert excerpt
   _form _form nopanel true

   fields, click on the drop-down field where you want to display the drop down
   1. If your field is not configured as a drop down, right-click it and choose 

      Insert excerpt
      _template_change _template_change nopanel true

   2. Select the Drop Down (Manual) template from the Serene Grey palette
4. The Drop Down

   Insert excerpt
   _property_tabs _property_tabs nopanel true

   will open
5. Drag across your drop-down view into the View Name field, found in the Basic Settings section of the View Attribute properties
   
   

6. Insert excerpt
   _save _save nopanel true

    the properties
7. Close and reopen the screen, then 

   Insert excerpt
   _lock _lock nopanel true

    the screen to see the changes