Choice values are appearing twice

[amaradiswamy]

Hi All,

We have a dopdown field called "type" in a "devices" table. Under devices table we have created 3 child tables laptops and desktops. we have added 10 choice field values to the parent table(in sys_choice table table is u_devices and element is u_type) but surprisingly in the dropdown it is showing each choice value twice(totally it is showing 20 choices). And one more problem is that when i am trying to create a laptop then in this field no choice values are shown, only for desktops only i can see the choices(each value twice).

Please help and advice on this.

Thanks and Regards,

Swamy

[amaradiswamy]

Hi Anurag,

Thanks for your reply.

No, coming in black only.

Regards,

Swamy

[Anurag Tripathi]

then either there are duplicates on the sys_choice table, or one value is coming from sys_choice table and one is being added on the form.

[amaradiswamy]

Hi Anurag,

we are not adding the choice values on the form with any g_form methods and we don't have duplicate also in sys_choice table, that's why i am also wondering about this situation.

At the time of CI creation, the choice values are coming correctly but after saving the record surprisingly each choice value is coming twice. Please help me and suggest on how to overcome this.

Regards,

Swamy

[Anurag Tripathi]

Never came across any such scenario...what i would do first is delete the choices and create them again...

[amaradiswamy]

If we delete the choice values then existing records will be effected, so is there any other way?

Regards,

Swamy