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