Conditional value list + 1

[grover970]

I have a simple conditional value list(which works fine) that lists some dynamic classifications. However if none of the classifications listed are appropriate I would like the user to be able to select "None". Is there a way to add a static value to this dynamic list?

[The Big Bear]

why don't yuo just add another classification and name is NONE.

what way it would be in the list

[eos]

In FM12, you can define a calc field, type text, as

ExecuteSQL ( "SELECT myField FROM myTO"; "" ; "¶" ) & "¶None"

and use the field for creating the value list.

[comment]

I have a simple conditional value list(which works fine) that lists some dynamic classifications. However if none of the classifications listed are appropriate I would like the user to be able to select "None". Is there a way to add a static value to this dynamic list?

You could define a calculation field (result is Text) =

List ( Classification ; "None" )

and use this field as the basis for your value list instead of the Classification field.

In FM12, you can define a calc field, type text, as

and use the field for creating the value list.

ExecuteSQL ( "SELECT myField FROM myTO"; "" ; "¶" ) & "¶None"

And when would this field be evaluated?

[eos]

And when would this field be evaluated?

EDIT_EDIT: OK, maybe it really is calculated a bit too late …

[comment]

At the right time to work.

<shrug>