Thanks Eric. Is what you're suggesting a manual solution? IE when a transaction is confirmed and the product is shipped the inventory field is manually revised to the new amount and if someone tries to put more then is in the stock field a "show region" appears saying "Out of Stock" triggered by a recordset? Would you recommend I follow the thread that I think "Best way to tackle inventory control? I have several ideas...need help" dated 2-17-2010 by sam308940? Is this a way to subtract what's ordered automatically from the Stock field? Finally, if I have a new cart requirement, would you then recommend I buy PowerStore?