if

[mainall]

I know this will be a simple question for most of you people but it is giving me lots of trouble. PLEASE HELP!

I have a file named orders- with fields stock no, mim, and price.

and another file name price list- with fields named stock no, mim1, price1, mim2, price2, mim3, and price3.

I have a lookup set on the stock no in the order file to copy the mim1, and price1. What I would like for it to do is if I enter a mim =to or larger than mim2 to copy price2 into the price field in the order file or if I enter a mim =to or larger than mim3 to copy price3 in the order file price field.

THANKS

FileMaker Version: 6

Platform: Windows 2000

[jscooper]

Rather than a lookup, set price to an auto-enter calculation. The calculation being a case function such as case(mim=>prices::mim3,price3,mim=>mim2,price2,price1). Of course, this assumes that mim3 is always greater than mim2 and mim2 is greater than mim1. I'm not sure what a "mim" is, so I don't know if this is the case. Also, once a value is in Price, changing mim won't update that value. Auto-Enter calculations only do their thing if the field is empty (this is fixed in FM7 BTW).

[mainall]

Thanks so much for your help, it worked just like you explaned. But sometimes mim2, and/or mim3 will have no entries, when this happens their is no price auto/entered.

mim1, mim2, and mim3 are the same as Quanity1,Ouanity2,Ouanity3. when a larger number is enter the price is difrent.

example... (Mim1 (2) price1 (3.00), (Mim2 (4) price2 (2.50)),( Mim3 (6) price3 (2.00))

thanks again

FileMaker Version: Dev 6

Platform: Windows 2000