I have a form for Products Use, and Inventory, and a Purchase order.

I am trying to determine if I use a "For Each Statement" or a "GetTotal Statement".

Here would be the theory;

when a product is used, it would count how many of that product were used in the Past (Selectable time, say 90, 120, 365 days), and put that number in the "Stock Level field" of the Inventory Field.

Then auto create a Product reorder report based on findings.

Should this script be put in the Parts used form, or the Inventory form?

Any suggestions would be helpful.