Hello everyone i am new in here and to filemaker too.

I need some help and hope you guys can help me.

I have filemaker 11 i am trying to display on my inventory layout a "header" this being the result of a validation.

Meaning i have a field called quantity. I want this header to check on the field quantity so if quantity is below certain level to display for example Re-Order if its between certain level display in Stock and if its over that level display Over stock.

i would like to know if you guys know how can i achieve this because i couldn't find anything related to what i am trying to accomplish.

Any help would be really appreciated.

Thank you in advance.

I've moved your post, because this doesn't have anything to do with Script Triggers. Not to worry.

What you need is a calc field, result text. It will look something like:

case (

Qty < myNumberField; "Reorder" ;

Qty < myOtherNumberField ; "In Stock" ;

"Over Stock"

)

Not sure what your field names are, and what numbers you are comparing.

Hi and thankx for pointing me in the right direction. just to clarify I have a field which is already a result of a calculation that field is named "carton qty" this filed would tell me how many cartons i have on my warehouse.

Now based on the number displayed on the "carton qty" field i want to display a header.

ie. if carton qty is less than 400 display re-order is carton qty is between 400 and 600 display in stock and if carton qty is more than 600 display over stock.

could you explain me how to achieve this or point me in the right direction?

Thank you again

I've explained this above, so I'm not certain where you're confused. You need a calculation field with a case statement.