Hello,
I am trying to set up a table in access that has to have the output as a number (for later conversion to other file for statistical analysis) however I want to create a form that displays a text from the dropdown menu that corresponds to the number in the table.
For example...
Table:
Color- options should be 1, 2, or 3 and has to be a number (1 means red, 2 means blue, 3 means green)
Form:
Color- options would be listed as red, blue, green in the drop down boxes (so that the person entering does not make mistakes by having to mentally convert red to 1 and then choose 1). If the person chooses red in the form the table would actually show 1 so that if you were to later export the table it would only contain numbers.
THANKS!