Hello,
I have a database with a table of my 'Customers', and a linking table called 'Purchases' (assigning purchases of items to customers) linked with an 'Items' table.
Currently, when a customer purchases an item, the Purchases table needs to be updated manually, and the stock of each item needs to manually be decreased.
I've been trying to work out a system that would allow me to select an item via a form for a customer, and allow me to press a 'Buy' button which then AUTOMATICALLY decreases the stock in the items table and records the Customer ID and Item ID in the purchases table. The later isn't entirely necessary, but would be nice if possible, my main source of problems is finding a way to get a system that allows an item to be bought, and have the stock thus decrease.
I've been fiddling around with this, with things like update queries, subforms, but haven't found a solution yet. Anybody have any tips or ideas?
Thank you!
Max
I have a database with a table of my 'Customers', and a linking table called 'Purchases' (assigning purchases of items to customers) linked with an 'Items' table.
Currently, when a customer purchases an item, the Purchases table needs to be updated manually, and the stock of each item needs to manually be decreased.
I've been trying to work out a system that would allow me to select an item via a form for a customer, and allow me to press a 'Buy' button which then AUTOMATICALLY decreases the stock in the items table and records the Customer ID and Item ID in the purchases table. The later isn't entirely necessary, but would be nice if possible, my main source of problems is finding a way to get a system that allows an item to be bought, and have the stock thus decrease.
I've been fiddling around with this, with things like update queries, subforms, but haven't found a solution yet. Anybody have any tips or ideas?
Thank you!
Max
