I cant seem to work out how to make a Product quantity change based on a sale i put though
These are my current relationships
from there you can see all my columns in each table, what my intial thoughts were with some advice from June was to have
a Quantity in my Order Table
a Quantity in my Sales table
Sales - Order = total quantity in my Products table
The problem with this is if i do this how do i make it so that i dont have to keep adding +1 to everytime i sell a perticular product
e.g if i sell a monitor to mike i put i sold 1, if i sell one to jake i have to write i sold 2 becuase i took the value from the pervious record any way around this?
I have my current updates done though a query, is there anyway of me doing it automatically
The way ive got it working is using an Update query with this code
These are my current relationships
from there you can see all my columns in each table, what my intial thoughts were with some advice from June was to have
a Quantity in my Order Table
a Quantity in my Sales table
Sales - Order = total quantity in my Products table
The problem with this is if i do this how do i make it so that i dont have to keep adding +1 to everytime i sell a perticular product
e.g if i sell a monitor to mike i put i sold 1, if i sell one to jake i have to write i sold 2 becuase i took the value from the pervious record any way around this?
I have my current updates done though a query, is there anyway of me doing it automatically
The way ive got it working is using an Update query with this code
Code:
[Purchase_Quantity]-[Quantity_Sold]
