Option Type on Field

fmhigue

Hi everybody:

I got a field call Customer Class on Customer Table.

Customer Class - Option
OptionString:
,,,Elite,,,Key,,,Preferred,,,Dealer,,,Choice,,Overseas,Value,Select,Potential,Target,CH11,Closed,DLR-Elite,,,DLR-Key,,,DLR-Preferred,,,DLR-Choice,,,DLR-Value,,,DLR-Target,NSA

I want to delete some options but when I remove do it I see numbers on the Customer Card form. Same thing happens if I add more classes after NSA.
What is wrong?

Thank you a lot

ufuk

Check option caption. Option string and the caption must have the same order. If the option string value has no caption then you only see numeric value of the string.

Also do not forget to update all the table after option string changement.

garak

internal the Option Field Type or variable is stored as an integer and begins with zero.

If you have following options:
,,,Elite,,,Key,,,Preferred,,,Dealer

Than is
Elite = Ingteger 3
Key = 6
Preferred = 9
Dealer = 12

so, when you are now change the OptionString valu to
,Elite,Key,Preferred,Dealer

than is
Elite = 1
Key = 2
Preff = 3
Dealer = 4

and if you not update your customer records, you see an customer which was formaly the option Dealer now an 12

I hope you understand this example ;-)

Regards