how to add a database field as drop down in input box

[#1]

Hi,

      I try to add Year field to an input box  as follows

Input Box Properties>

                  Constraints>

                          Value List>

                               Select "Predefined Values in Drop Down">

                                              Deslect "Enable Edit Expression Dialog" >

                                                           select "Listed Values" >Write an expression as =Year

Its working fine if and only if Year field contains only one value.But the field contains more than one value.

Please help me out to fix it.

Thanks:

Irfan Ghori

[Gysbert_Wassenaar · Accepted solution]

On the Constraints tab check the Listed Values option and enter =Concat({1} distinct Year,',') as expression.

[#3]

Hi Gysbert,

     I thanks from bottom of my heart , its working.