Hi, I have this database where I want to see stock items left adter a sell some items.
I have two tables: sell table and warehouse table.
I have query2 to calculate how many stock items are left in warehouse.
I want to see it in my sell query hoewver after I add it I can no longer enter data using the query as access does not allow to enter data if query is made from tables and queries I heard.
I attach my db, any ideas how to solve this?
Keep in mind I need only to see how much stock items are left I do not need to store the numer anywhere as it is calculated on the fly, and needed not to sell more item than there is stocked.
I have two tables: sell table and warehouse table.
I have query2 to calculate how many stock items are left in warehouse.
I want to see it in my sell query hoewver after I add it I can no longer enter data using the query as access does not allow to enter data if query is made from tables and queries I heard.
I attach my db, any ideas how to solve this?
Keep in mind I need only to see how much stock items are left I do not need to store the numer anywhere as it is calculated on the fly, and needed not to sell more item than there is stocked.
