Option Type on Field

fmhiguefmhigue Member Posts: 290
Hi everybody:

I got a field call Customer Class on Customer Table.

Customer Class - Option

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


  • ufukufuk Member Posts: 514
    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.
    Ufuk Asci
  • garakgarak Member Posts: 3,263
    internal the Option Field Type or variable is stored as an integer and begins with zero.

    If you have following options:

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

    so, when you are now change the OptionString valu to

    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 ;-)

    Do you make it right, it works too!
Sign In or Register to comment.