Return to FileMaker.com
I have Table called Stock with field called "Quantity in stock", "Re-oder Level" and "Status".
I want the status to tell me if the item is in stock or Low on stock or out of stock. Can someone please tell me a if function that i could use?
I would (almost) always use a Case Statement. It is more flexible.
You could try:
Quantity in stock <= 0 ; "Out of stock" ;
Quantity in stock <= Re-order Level; "Order more stock" ;
This will check if you are out of stock, below the re-order point, or have enough stock.
Retrieving data ...