Define a value list

[aria]

Hi All,

Is it possible to define a value list which displays one value such as 1, but stores a different value such as Yes?

Thanks for any help.

A

[Matthew F]

Usually its the other way around. You can define a value list of numbers and then display 'yes' or 'no' using the Format... Number settings.

I think your way you would need define a secondary calculation field which calculates 'yes' or 'no' based on the numeric value in the primary field.

[comment]

It's possible, if the values are in a table with two fields. Define the value list to use values from the first field and display values from the second one. Use a pop-up menu, checkbox or radio button set to select the value.

[aria]

I have around 50 fields to have Yes or No.

I created the following calculation:

If(Answer="1"; "Yes") & If(Answer="2"; "No")

That is going to be lots of calculations for 50 fields. Plus how do I insert Yes and No into each 50 fields?

Is there any other way to do this? :

Thanks,

A

[Matthew F]

Comments solution, above, should work. You only need to define two extra fields and one value list. You can then use the same value list as many times as you want.

[T-Square]

Just a programming point: it is more common to use 0 for No or False, rather than 2. With No set to zero, a simple assertion of the field is its own test. This is simplified as: If(Answer; "Yes"; "No"). This assumes that Answer has only two values 0 & 1. Your calculation suggests that there is more going on here, though, since you have separate tests of Answer for two different values.

David

[aria]

You all have been very helpful.

Thanks for all the help,

A