Hello, I have been looking for ways to make a dropdown menu in the form to show a option while recording number into the table, for example, to show (Yes, No, Don't Know, Missing data), and to record 1,2,3,4 in table respectively.
Some people said do the lookup field and do 2 columns with 1 bound column set the column width as 0cm;7cm, and it has worked perfectly, except, now when I need to extract data to excel and analyze it, it just shows me the yes, no, don't now, missing data, instead of 1234.
What can I do to solve this?
Some people said do the lookup field and do 2 columns with 1 bound column set the column width as 0cm;7cm, and it has worked perfectly, except, now when I need to extract data to excel and analyze it, it just shows me the yes, no, don't now, missing data, instead of 1234.
What can I do to solve this?