How to display several field values in an expression (for an input box) ?

[#1]

Hi,

I would like to display in the "listed values" expression of an input field (constraint part), the possible values of a field. My problem is, as the result contains several values, the expression only displays null value.

Do you know how to solve this problem ?

Best regards

P.S : I know, usually I can directly use a listbox of the field or set analysis but I'm in a very particular case.

[fernandotoledo · Accepted solution]

You can use the "getfieldselections ( Field , ';' , 10 ) " function.

It will return an string with all possible values separated by ';'

If there is more values than 10 it will display something like "25 of 1,423,324"

You can set the parameters ';' and 10 as you wish. See help for more details in this function.

Best Regards

Fernando D'Agosto

[#3]

OK, great

That's exactly what I was looking for,

thanks a lot