# Showing wrong Choice option as selected ODK-X

**URL:** <https://forum.odk-x.org/t/showing-wrong-choice-option-as-selected-odk-x/702>\
**Category:** Support\
**Created:** [May 20, 2020, 2:06pm UTC](https://forum.odk-x.org/t/showing-wrong-choice-option-as-selected-odk-x/702 "2020-05-20T14:06:43Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![cmuchuchuti](https://odkx.b-cdn.net/user_avatar/forum.odk-x.org/cmuchuchuti/32/356_2.png) [@cmuchuchuti](https://forum.odk-x.org/u/cmuchuchuti)\
**Post date:** [May 20, 2020, 2:06pm UTC](https://forum.odk-x.org/t/showing-wrong-choice-option-as-selected-odk-x/702/1 "2020-05-20T14:06:43Z")

</div>

I am having a funny behavior in ODK Survey. I have a select\_one question in my Survey sheet. The options are as follows:

Value Display.text  
1 Drug 1  
2 Drug 2  
3 Drug 3  
…  
20 Drug 4

So Drug 1 has value of 1, Drug2 has value 2 and so forth.

When I select an option for example Drug3, the system stores the correct value of 3.  
However if I open the record for editing, it will be showing Drug17 as selected even though the value is 3 in the database. For value 3 it is supposed to have Drug3 as selected option.

I am wondering if anyone had an experience with this. Unfortunately this is happening on 5 questions.

Any help will be appreciated.

---

<div class="post-metadata">

**Author:** ![elmps2018](https://odkx.b-cdn.net/user_avatar/forum.odk-x.org/elmps2018/32/105_2.png) [@elmps2018](https://forum.odk-x.org/u/elmps2018)\
**Post date:** [May 20, 2020, 4:02pm UTC](https://forum.odk-x.org/t/showing-wrong-choice-option-as-selected-odk-x/702/2 "2020-05-20T16:02:07Z")

</div>

For select\_one, if you are using integers for responses you should either switch to select\_one\_integer or use =“1” in the excel. I am not 100% sure if this is causing your current problem but it’s a known issue so it’s good to address either way. Another possibility is that there’s an issue in the choices sheet if there are multiple forms writing to the same table, the tableid=formid should have the choices. Hope one of those solves it!

---

<div class="post-metadata">

**Author:** ![cmuchuchuti](https://odkx.b-cdn.net/user_avatar/forum.odk-x.org/cmuchuchuti/32/356_2.png) [@cmuchuchuti](https://forum.odk-x.org/u/cmuchuchuti)\
**Post date:** [May 21, 2020, 10:42am UTC](https://forum.odk-x.org/t/showing-wrong-choice-option-as-selected-odk-x/702/3 "2020-05-21T10:42:20Z")

</div>

@elmps2018, thanks will try those alternatives.
