I have it all set up for my satock control, I have the primary keys and foreign keys too, so in SQL how is it to update my stock control when I sell item so I could have products deleted from stock and inserted to sold_product tables please.




tbl_Stock ( stockID Primary Key)
tbl_product (productID PK stockID Foreign key)
tblProduct_sold ( a result of m:m relationship between tbl_sales and tbl_Product)
tbl_sales (saleID PK)