Unanswered: Scout Leader needs help with fundraiser database
First off. I have created a MSAccess database and it works but involves too many steps to complete after each sale inventory check.
What I am trying to accomplish is: Everytime that I enter in sales for a boy scout I need the database to remove that said product from the inventory. Currently I havea dummy record called _sold on my checkout form that I have to enter those sales into first so that it takes it off the inventory. How do I get the amount of each product taken off the inventory everytime I enter in the sales for the scouts.
I am doing the best to teach myelf access as I am a full-tim Navy Chief but this access issues is killing me. I appreciate and support I can get on this.
I can send the database if someone wants to try and help me with it also