Invalid value error-dropdown

[Danny]

Hi,
I created a new dropdown field called outcome which includes two choice items. When attempting to select one of them, I received “The value you entered isn’t valid for this field” error. Attached is my design screenshot. Do I need to define my field outcome as a text data type?

TIA
Regards,

 

[DHookom]

It seems you are attempting to store a text value in a numeric field. Rather than a Value List, consider using a small lookup table to store the drop-down values. These tables typically have a numeric primary key (autonumber) that gets stored in the main tables

 

[June7]

Agreed.
Your options:
1. define field as text type
2. keep number type but use a value list that saves a number while showing text
set combobox for 2 columns with widths 0";1" and ValueList of 1;LEE;2;Withheld
This means will have to use combobox on report (will look like textbox) or an expression in textbox on report to convert number to text equivalent.
3. keep number type but use a table as RowSource
again, set combobox for 2 columns and widths 0";1"
include this table in reports to retrieve text equivalent