If I understand this correctly, the challenge here is that each item may have different re-order point so you can't just search for all records whose inventory count is less than a single value.
I'd place a calculated field in the inventory table. Something like:
If ( Amount_In_Stock < Reorder_Level , "Reorder" , "" )
and set the calculation to return "text".
I can then specify "reorder" in this field when performing a find to just find the items needing restocking.
That worked thanks.