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

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

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