Our last "conversation" got me thinking and searching some more. I came
across some advice from Albert Kallal and downloaded an example inventory
database that uses a query to track inventory.

http://www.members.shaw.ca/AlbertKal.../msaccess.html

I figure something like this would be best and simplest. I work with a lot
of technophobes so a query that updates itself each time they open it would
be best. This way they see all the inventory at a glance and can see what we
are low on. The field, UnitsMade, would be in the production table,
UnitsSent would be in the Kit Contents table and an additional Lost&Tossed
field would be in an Inventory/Storage table (Pkey Batchcode or description)
and these would be filled out thru various subforms.

The only thing I can't figure out is how to filter the results so that the
batchcodes that have been reduced to zero don't show up in the results. At
the worst, users would have to filter the results in the datasheet view.
They will know or do know how to do this at least.

What do you think? Am I overlooking some pitfalls?

Thanks for letting me pick your brain,
Access Greenhorn