Re: Maintain cost after order submitted and price changes??
Originally Posted by T. McConnell
All I want to really mess with is the best way to manage my inventory and control the costs as it changes with each batch of stock I get in.
Well, in my view the easiest way to do that is to save the selling price in the order details table along with quantity. It would be simple to populate that field when the user selects a product from the combo using the second method here:
Microsoft Access MVP 2007-2019
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.