K kryten Registered User. Local time Today, 12:38 Joined Jul 24, 2004 Messages 40 Jul 25, 2004 #1 Hi all, I'm trying to build an inventory form that will automatically reduce the UnitsOnHand total by the quantity ordered. Any tips on code to do this would be greatly appreciated!!
Hi all, I'm trying to build an inventory form that will automatically reduce the UnitsOnHand total by the quantity ordered. Any tips on code to do this would be greatly appreciated!!
ghudson Registered User. Local time Today, 15:38 Joined Jun 8, 2002 Messages 6,193 Jul 25, 2004 #2 You need two tables. On table to store the inventory "in" items. One table to store the inventory "out" items. Use a query or function to sum the items against each table for your inventory totals.
You need two tables. On table to store the inventory "in" items. One table to store the inventory "out" items. Use a query or function to sum the items against each table for your inventory totals.
