>Hi!
>
>I have a table called ORDERS DETAIL, with a field I have named DISCOUNT.
>
>I would like to set up a validation rule that only allows a number between 0 and 1, but each time I try I get an incorrect syntax error. I am building my first application if FoxPro and have not used the expression builder before and do not know how to create the expression properly. I would appreciate any help with this expression.
>
>Also, what data type would you recommend I use? I want the data to be a percentage (hence, between 0 and 1). How do I make the format for this field a percentage? I can do this very easily in Access, but I refuse to use Access anymore. I am dedicated to learning FoxPro!!!!!!!
>
>Thanks in advance for your help.
>
>Jason
Type numeric 4.2. Validation rule :
between(myPercentage,0,1)
Cetin