Hi,

I'm new to FM and FMM, any help you can give will be appreciated. I used to use Access and was probably a novice user with that.

I am building an inventory db and am trying to write a script that will alert me when product levels are low and when I need to re-order. The on-hand field and the re-order field are in the same table. Using the SM I was able to make an alert script with pop-up dialog box. I am now trying to figure out how to capture the items (records) that need to be re-ordered, so I can make a proper report to print-out. Right now, all the script does is let me know when to re-order, it doesn't tell what needs re-ordering or how many to order.

Here's what I've tried building:

Less than or equal to statements and including a preview command, that just leaves me with a preview with all the records. The problem seem to be that the less than and equal to doesn't want to run in the same table.

Find - but I can't get them to find in comparison to the re-order field below

Sorting - But that just gives me the information sorted by name or one set of numbers. I need them to cross reference another number.

How can I make this work?

You can make a calculation field that would be true if the On-Hand is <= Reorder level. You can then find all records where this is true.

You may want a reordered flag so you don't order more than once.

Thank you so much! I was very frustrated this afternoon about this challenge. Thank you!