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...